Attempt to create a transformation results in error "transf. does not exist

[annette_frei]

Hello,

We're using BI 7.0 in my dept. I have a Data Store Object that I want to connect with a transformation to my DataSource. All objects are BI 7.0 objects, not 3.x. I right click my DataSource and select "create transformation" - as described in the BI documentation. I enter my DSO object as destination in the pop-up. As soon as I click on "execute" to confirm all entries in the pop-up, I get the error message "transformation does not exist, see long text". In the long text I find "The transformation specified by transformation ID , source and target , does not exist.". Well - of course my transformation doesn't exist yet, I wanted to create it! Does anyone share my unfortunate experience and found a way out?

Thanks for any tips you can give me! Annette

[Former Member · Accepted solution]

Hi,

goto your DSO right click -> select create transformation -> in the next screen give your data source name as soure to your DSO, in this way you can create it.

Regards

Sankar

[annette_frei · Accepted solution]

Hello Sankar,

Thanks, but this results in the same error. I've also created an InfoSource and tried to create a transformation to it and from it - same error. And I've tried to create a transformation to and from an InfoObject - same error.

Any other ideas?

Thanks again, Annette

[Former Member]

Hi .. even i faced the same error while creating Transformation to map D/S to Master data I/O - Transformation does not exist (see long text).. and was not getting any other error.. i activated S/Sytem, re-activated Master data, replicated D/S ( BI7 D/S).. but no luck.

Keeping to this thread, i tried for SU53 jst after the error .. and found the error..

Roles was not defined poperly.

if facing same error- i will suggest to have a look at

Auth Object : S_RS_TR

Activity should have 23 in it.. having * will be prefered for all Auth Field in this Auth Object..

hope it helps

[Former Member]

hi annette,

assign the datasource to your infosource. then right click on your ods and create the transformation.

please let me know...

regards,

sameer

[Former Member]

Do you see the ODS as a standalone object ?

Is the ODS activated ?

Is the datasource activated n in place ?

Try logout n logback in ...

[annette_frei]

Hello Roberto and Sameer,

Thank you for your ideas. Everything is active and in place, and I have closed BI and re-opened it to try creating the transformation.

Sameer, there is no such thing as a "standalone" ODS, you probably meant "standard"? Yes, my ODS is a standard object.

Thanks, Annette

[Former Member]

good it worked for you. standalone ods is idea of roberto... not mine as that's a new term for me as well.

regards,

sameer

[annette_frei]

Hello Sameer,

The problem hasn't been solved yet. I still can't create a transformation.

Thank you for your attention, however! Any other ideas?

Annette

[Former Member]

hi annette,

if you have your infosource active then right click infosource --> create transformation... a pop-up will appear

select object type as ods/dso --> select your ods/dso from drop-down list (try not to enter it but select from drop-down link) --> select appropriate source system --> say YES (green arrow button)

you shall be able to create one.

please let me know...

regards,

sameer

[annette_frei]

Hello Sameer,

YES! This part worked! I connected now the ODS to the InfoSource successfully. Now I still have the problem that I cannot connect the DataSource to the InfoSource, the same error message appears: transformation does not exist.

It seems there may be something wrong with my DataSourse, but what? It's active, and I can load data to PSA without problems. Do you have an idea what to do here?

Thanks again, Annette

[Former Member]

hi annette,

you previously said that your infosource is active. how can it be active without assignment to datasource? could you please tell me what exactly happening? you want to assign datasource to infosource OR you want to connect ods to infosource/datasource (transformation)

regards,

sameer

[annette_frei]

Hello Sameer,

In BI 7.0 it's not mandatory to have an InfoSource, you can connect a DataSource directly to a DSO object (formerly known as ODS object). Since InfoSources are independent objects themselves in BI 7.0, it's possible to have an active InfoSource without assignment to a DataSource.

What I would like to accomplish is create this direct connection between DataSource (also an independent object in BI 7.0) and a DSO object. All objects are active.

Thank you so much for your help and for trying to understand the problem properly. Best regards, Annette

[Former Member]

hi annette,

i just created one in my system (i'm also on BI 7.0) and it worked. i created a transformation between ods and datasource and managed/maintained all the rules per requirement and it's loading the data. the steps i followed...

ods --> create transformation --> object type (datasource) --> pass on appropriate datasource and source system --> maintined all the rules --> active

regards,

sameer

[annette_frei]

Hello Sameer,

I'm doing the exact same and my error occurs after your step 4 "pass on appropriate datasource and source system".

Regards, Annette

[Former Member]

weird. can you please give me the message class/number. this is interesting...

regards,

sameer

[annette_frei]

Hello Sameer,

Yes, isn't it weird? Here is the message number: RSTRAN010. I hope this is what you mean. This number appears in the long text of the error message.

Thanks for your help! Annette

[Former Member]

hi annette,

can you please create a infosource and then try to create your transformation. i know in BI 7.0 they are independent of eachother but still... maybe you can try in your dev system.

regards,

sameer

[annette_frei]

Hello Sameer,

I've tried this several times to no avail.

Regards, Annette

[Former Member]

i tried several times in our system and it's working here. i'm sorry i couldn't be any help (though issue IS interesting) and please, if you get a solution on this... please keep me posted.

regards,

sameer

[Former Member]

hi annette,

this is 1 of the possibility. i replicated the issue in my system and this is what i found out...

when you or whoever replicated the system (r/3 system connected with bw) he/she must have replicated the datasource as a 3x version and NOT as a 7x version. if that's the case, then you must have infosource inbetween (as 3x object you can't connect directly with datasource) and update rules (no transformation works). if that's what happened... then system will not allow you to create a transformation and will give you that error message. so please check if the datasource from r/3 got replicated properly (you have 2 options... replicate as 3x object OR replicate as datasource object 7x)

hope this helps...

regards,

sameer

[annette_frei]

Hello Sameer,

Interesting! I'm sure, though, that the DataSource is a BI 7.0 object, the old ones have a small square in front of them and this one doesn't.

What you will probably find interesting, however, is that I was able to successfully build a transformation to a 3.x InfoCube from my Datasource in question, so I think this proves your point with the release difference. Do you know how I can check the release of my objects?

Thank you very much for your intense research and your valuable help, Annette

[Former Member]

hi annette,

congrats!! for your solution. umm... well when you replicate the system it ask you which version you want the object to be replicated as. is that what you asked me?

just out of curiosity... could you please tell me how finally system let you create a transformation (b'cos previously it was not)

regards,

sameer

Message was edited by:

sameer chitale

[annette_frei]

Hello Sameer,

It worked today, the problem is fixed! I'm quite sure it was an authorization issue that I wasn't able to build transformations before. I almost couldn't believe it when it worked today.

Thank you so much for your help again, Sameer.

Have a nice day, Annette