Skip to main content
Solved

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

  • December 16, 2022
  • 2 replies
  • 119 views
K
Hero (Partner)
Forum|alt.badge.img+10
  • kvbe
  • Hero (Partner)
  • 190 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?

 

 

 

Best answer by MMcK

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. 

View original
Did this topic help you find an answer to your question?

2 replies

M
Hero (Customer)
Forum|alt.badge.img+10
  • MMcK
  • Hero (Customer)
  • 59 replies
  • Answer
  • December 16, 2022

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
1 person likes this
  • K
    kvbe
K
Hero (Partner)
Forum|alt.badge.img+10
  • kvbe
  • Author
  • Hero (Partner)
  • 190 replies
  • December 16, 2022

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

 

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings