Hello, I am new to DataMigrator and this forum. I duplicated...

[Madhav Achar]

Hello,

I am new to DataMigrator and this forum.

I duplicated a workflow and procedure to a new folder that points to a different source and destination database. I made sure I pointed the new flow to the newly copied objects but I get the following error:

SOURCE_TABLE_IS :

0 ERROR AT OR NEAR LINE 46 IN PROCEDURE get_account_object_date

THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: WHERE

Request failed validation, not executed.

THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SOURCE_ACCT

0 ERROR AT OR NEAR LINE 58 IN PROCEDURE ipf/etl/presentation/dxp/get_accoun

t_object_date

ERROR WITH DIALOGUE MANAGER COMMAND: -READFILE SOURCE_ACCT

DEP_0 get_account_object_date Return Code = 2907

DEP_4 sf_account_stg_dxp Return Code = 2907

Any help will be much appreciated.

Thank you.

[Manoj Chaurasia]

Hi Madhav

Welcome to myibi!! Please post the data flow code so we can see what is being executed.

[Madhav Achar]

Thank you for reaching back Chuck!. Below is the code in our procedure:

-*SET &ECHO = ON;

-*SET &ECHO=ALL;

-DEFAULT &LAST_UPDATED_DATE = ;

-DEFAULT &&LAST_UPDATED_DATE= ;

-DEFAULT &LASTMODIFIEDDATE = ;

-DEFAULT &&LASTMODIFIEDDATE= ;

-DEFAULT &SOURCE_TABLE_NAME=;

-DEFAULT &ROWCOUNT=;

-DEFAULT &&CM__TARGET=sf_account_stg_dxp

-*DEFAULT &&CM__SOURCE=account_dxp

-*DEFAULT &&CM__SOURCE=broker_role__c_dxp;

-DEFAULT &&CM__SOURCE=;

-DEFAULT &&RET_CODE= 0;

TABLE FILE ACCOUNT_TABLE_UPDATED_DATE_DXP

WHERE TABLE_NAME=&&CM__TARGET

PRINT *

-*PRINT TABLE_NAME, LAST_UPDATED_DATE

ON TABLE HOLD AS ACCT_TABLES_DXP

END

-RUN

-READFILE ACCT_TABLES_DXP

-RUN

-TYPE LOCAL_VALUE OF LAST_UPDATED_DATE VALUE IS : &LAST_UPDATED_DATE

-SET &&LAST_UPDATED_DATE=&LAST_UPDATED_DATE;

-TYPE GLOBAL_VALUE OF LAST_UPDATED_DATE VALUE IS : &&LAST_UPDATED_DATE

-TYPE GLOBAL_VALUE OF CM_TARGET of &&CM__TARGET

-TYPE LOCAL_VALUE OF SOURCE_TABLE_NAME IS : &SOURCE_TABLE_NAME

-* SOURCE LASTMODIFIEDDATE 06/09/2021 09:10:19.000000

-* TYPE LOCAL_VALUE OF LASTMODIFIEDDATE VALUE IS : &LASTMODIFIEDDATE

-TYPE SOURCE_TABLE_IS : &SOURCE_TABLE_NAME

TABLE FILE &SOURCE_TABLE_NAME

WHERE LASTMODIFIEDDATE GT &LAST_UPDATED_DATE

SUM CNT.LASTMODIFIEDDATE AS ROWCOUNT

-WHERE ID=0010B00001l254TQAQ

- WHERE LASTMODIFIEDDATE=06/09/2021 09:10:19.000000

ON TABLE SET ASNAMES ON

ON TABLE SET HOLDLIST PRINTONLY

ON TABLE HOLD AS SOURCE_ACCT_DXP

END

-RUN

-READFILE SOURCE_ACCT_DXP

-TYPE &ROWCOUNT

-RUN

-TYPE LOCAL_VALUE OF LASTMODIFIEDDATE VALUE IS : &LASTMODIFIEDDATE

-SET &&LASTMODIFIEDDATE=&LASTMODIFIEDDATE;

-TYPE GLOBAL_VALUE OF LASTMODIFIEDDATE VALUE IS : &&LASTMODIFIEDDATE

-*SUM MAX.LASTMODIFIEDDATE AS TEMP_DATE

-IF &ROWCOUNT GT 0 GOTO SET_RET_CODE;

-TYPE NO NEW RECORDS FOR INSERT OR UPDATE

-EXIT

-SET_RET_CODE

-SET &&RET_CODE= 99;

-TYPE FOUND NEW RECORDS FOR INSERT OR UPDATE

-TYPE VALUE_OF_RET_CODE IS : &&RET_CODE

- &

-EXIT

[Manoj Chaurasia]

These two lines of code should not have a - at the beginning. Maybe you meant to have them as comments -*

-WHERE ID=0010B00001l254TQAQ

-WHERE LASTMODIFIEDDATE=06/09/2021 09:10:19.000000

[David Beagan]

The code you posted, when it runs it does not have a value for &SOURCE_TABLE_NAME and so uses the -DEFAULT value of a blank. When it gets to the lines:

TABLE FILE &SOURCE_TABLE_NAME

WHERE LASTMODIFIEDDATE GT '&LAST_UPDATED_DATE'

 

It sees nothing for the table name for &SOURCE_TABLE_NAME so then continues on to the next line and tries to use WHERE as a table name, and doesnt find one. Hence the message:

0 ERROR AT OR NEAR LINE 46 IN PROCEDURE get_account_object_date

THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: WHERE

[Madhav Achar]

Thank you all. I found the issue and it was just that I forgot to update the synonym for table ACCOUNT_TABLE_UPDATED_DATE_DXP to point to it.