Skip to Content
avatar image
-1
Former Member

Warning Status in Loading BW data to BPC

Hi,

The client ask us to test the new QA server environment. Part of the testing is to load data from BW Cube. When we do that the status is "Warning" and there are rejected records on the package. We checked the transformation file and it is identical to the PROD server. Another thing the loading of BW data to the DEV also produce "Warning" message. In the Prod server the loading is successful but the task at hand is to test the new environment in Q for back up purposes.

I attached a screenshot for the result of the package of Q server (Error 3 and Error 4) and Dev serv (Dev1 and Dev2). And i attached the transformation file for PROD and Q (Compare 1). Any feedback will be much appreciated.

Regards,

error-3.png (36.1 kB)
error-4.png (22.5 kB)
dev1.png (30.0 kB)
dev2.png (28.4 kB)
compare-1.png (24.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Feb 01 at 04:40 PM

    If you re-validate the transformation and conversion files again with the data that is giving the warning do you get any errors? Often the diagnostics produced by the validation process will point to the incorrect data or data that cannot be mapped due to string size.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01 at 10:23 PM

    Hello,

    Do you have exactly the same data in the BW cube that you load in QA and Dev? If the data that you are loading is not the same then that could explain the differences in the result.

    Best Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01 at 04:49 PM

    Hi Peter,

    Yes I did validate the transformation file and no errors came up. The thing is this transformation file in the Q server is identical to the one in the PROD server (screenshot Compare1) except in the PROD the data load is successful.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01 at 06:23 PM

    First of all - it's a bad idea to use "Insert File" instead of correct "Insert Image". It's hard to read the question, please correct.

    P.S. And please accept correct answer for your previous question!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01 at 07:20 PM

    Hi Vadim,

    Apologies for that. Here are the screenshot

    Result of Q server

    Result of Q server pt 2

    Dev server

    Dev server 2

    Comparison of transformation file of Q server and Prod server (right)

    Regards,

    Add comment
    10|10000 characters needed characters exceeded