Solved

BUG - Data migration - Attribute string limited? / How to view temp table

  • 16 December 2022
  • 2 replies
  • 89 views
K
Rank
Userlevel 4
Badge +9
  • kvbe
  • Hero (Partner)
  • 141 replies

We were in progress of debugging why a certain data migration job was not importing data correctly and we got a couple of issues/bugs while debugging. 

 

Attribute string field

We wanted to use the attribute string to verify if the data was read correctly BUT it looks like the attribute string is cuttoff at a certain size? (1922 chars?)

This is quite tricky as we could not debug if the data went in or not?

 

View Temporary table created by job?

When creating a job with CREATE_TABLE_FROM_FILE it seems its impossible to view the table created by this job? For example with Quick reports?

 

 

 

icon

Best answer by MMcK 16 December 2022, 10:19

View original

2 replies

M
Rank
Userlevel 2
Badge +10

Hi @kvbe

We’ve been able to view the IC_ tables using quick reports without any problems.  You don’t need the _TAB at the end of the name.  If you still get permission problems, have you tried when you’re logged in as IFSAPP?

I don’t know what the overall limit on attributes would be, hopefully someone else can help you with that. 

K
Rank
Userlevel 4
Badge +9

@MMcK  indeed, removing the _TAB makes it, that it works! Thanks for that!

 

Reply


Terms & ConditionsCookie settings