on 04-25-2017 1:39 PM
Hello Experts,
I am facing this error in BPC while executing a DM package link. I also checked this thread mentioned below. But not relevant for me.
We have similar offline environment both in production and test system where we have the same package link and it runs successfully in test system also we can validate the transformation file successfully. Plz suggest !
SYSTEM Details:
https://archive.sap.com/discussions/thread/3935727
Tranformation file validation:
Package link error:
Transformation file:
Conversion file:
Just google for any online JavaScript tutorial... On most sites you will also get the online testing tool to execute JavaScript code in the browser window.
For your case the code will be:
* js:%external%.toString().slice(-4)+"."+"JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC".substr((%external%.toString().slice(-7,-5)-1)*3,3)
in the online testing tool test this string:
alert("30.02.2021".toString().slice(-4)+"."+"JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC".substr(("30.02.2021".toString().slice(-7,-5)-1)*3,3));
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
The issue was the .cdm file of the conversion file in BW backend UJFS was corrupted. This was fixed and the issue got resolved. Now we have a different issue. Will comeback with more details soon.
Regards,Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vadim,
Finally, the issue is resolved and main culprit of the issue was format type in the conversion file. We changed it from DATE to TEXT and it worked. Thanks for all the help and suggestion. Can you help me with some docs or links on Conversion file using java script? Thanks in advance!
Regards, Suraj Jaiswal
And where is you data file sample?
P.S. Please show it in notepad!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
16 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.