Skip to Content
0

BPC error - Failed parse transformation file:unclosed element tag; '>

Apr 25, 2017 at 12:39 PM

216

avatar image
Former Member

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:

wykaw.png (115.2 kB)
rfs6t.png (79.9 kB)
y0zfa.png (9.4 kB)
howtj.png (14.0 kB)
ljene.png (115.2 kB)
carz1.png (79.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Apr 25, 2017 at 02:28 PM
0

And where is you data file sample?

P.S. Please show it in notepad!

Show 6 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi, Data file sample is like this:

ioxou.png (10.9 kB)
0

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

0
Former Member
Vadim Kalinin

Thanks for the reply and suggestion Vadim. I tried the the way you suggested, it still failed :(

l7van.png (8.1 kB)
rk5sx.png (6.0 kB)
0

Try to replace

AMOUNT=*COL(2)

with

SIGNEDDATA=*COL(2)

0
Former Member
Vadim Kalinin

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

0

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.

0
avatar image
Former Member May 02, 2017 at 09:10 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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...

0
Former Member
Vadim Kalinin

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

0
Vadim Kalinin May 03, 2017 at 12:52 PM
0

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));

Share
10 |10000 characters needed characters left characters exceeded