on 08-10-2022 11:19 AM
I am using SAP Data Services Designer 14.2.6 with Oracle data store. It was work ok and suddenly it starts show the below message that this when I click any query in any data flow. Can you please help me resolve this error
---------------------------------------- Here is the error message ----------------------------------------------------------------
(14.2) 08-09-22 13:07:39 (E) (6360:7796) RES-020107: |SESSION __JOB_DS_JIT_VIEWDATA_|DATAFLOW __DF_DS_JIT_VIEWDATA_|STATEMENT <GUID::'47d414c2-8484-47a6-99a3-8b0a04bcb076' QUERY qry_Policy_ext01>
Referencing an undeclared variable <$PV_SourceSystem>. Declare the variable in the context that it is being used.
(14.2) 08-09-22 13:07:39 (E) (6360:7796) RES-020107: |SESSION __JOB_DS_JIT_VIEWDATA_|DATAFLOW __DF_DS_JIT_VIEWDATA_|STATEMENT <GUID::'47d414c2-8484-47a6-99a3-8b0a04bcb076' QUERY qry_Policy_ext01>
Referencing an undeclared variable <$PV_SourceSystem>. Declare the variable in the context that it is being used.
--------------------------------------------------------------------The variable already defined as below
Hello Issac,
As per your screenshot,
You have added referenced variable as a parameter. System is expecting a variable for ths declaration.Goto tools and add this as a global variable and remove from parameter. Parameters can't be defined at Job level.
Do this and let me know.
Best Regards,
Vibhor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.