Madhav Achar Posted August 5, 2021 Share Posted August 5, 2021 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. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted August 5, 2021 Share Posted August 5, 2021 Hi Madhav Welcome to myibi!! Please post the data flow code so we can see what is being executed. Link to comment Share on other sites More sharing options...
Madhav Achar Posted August 5, 2021 Author Share Posted August 5, 2021 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 Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted August 5, 2021 Share Posted August 5, 2021 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 Link to comment Share on other sites More sharing options...
David Beagan Posted August 5, 2021 Share Posted August 5, 2021 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 Link to comment Share on other sites More sharing options...
Madhav Achar Posted August 5, 2021 Author Share Posted August 5, 2021 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now