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:
- BPC 10.1 NW Standard.
- SAPK-81009INCPMBPC
- SAPKW74014
- EPM ADDIN – Version : 10.0 SP 25 Patch 3 .Net3.5
https://archive.sap.com/discussions/thread/3935727
Tranformation file validation:
Package link error:
Transformation file:
Conversion file:
And where is you data file sample?
P.S. Please show it in notepad!
Test file with only few lines.
In the header remove ",," at the end.
And instead of mapping each TIME member in conversion file it's better to use JavaScript
Thanks for the reply and suggestion Vadim. I tried the the way you suggested, it still failed :(
Hi Vadmin, tried With signedata also, same error :( . Have raised a ticket to SAP to loo into it. Will update when there is a solution. Feel free to advise further.
Regards, Suraj Jaiswal
First - my name is Vadim...
Second - try to export some data from the model to file having nothing in the mapping section of transformation file.
Show the export file here.
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
As I already told you it's a bad idea to perform conversion of TIME using one to one mapping.
Use single line Javascript in the conversion file...
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
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));