Error while logon

[former_member203645]

Hi Guru,

Please help me in resolving this issue, when I am trying to log in then I am seeing this error message below.

In CMC, I tested my repository and it is showing as success, Also in DS Repository manager it looks good.

[DayaJha]

Hi RUC,

Could you please check the below point in your server.

• Connection between Database & BODS Server.
• Are you able to connect Database (DB2) through ODBC or not?

If your connection is working finr then please refer below link for your issue.

how to change the Database Connection String in CMC?

http://www.forumtopics.com/busobj/viewtopic.php?t=189146&start=0&postdays=0&postorder=asc&highlight=...

Or

If it was related to DB2 issue Please refre below SCN Thread

http://scn.sap.com/thread/3194916

KBA:

1615554 - Error: Database connection failed to allocate HENV, required to perform any ODBC operation - Data Services

https://service.sap.com/sap/support/notes/1615554

1758078 - Logon to Data Services Designer fails with Database Error for user login other than Administrator after upgrading to SP3, Data Services 4.0

https://service.sap.com/sap/support/notes/1758078

Thanks,

Daya

[Former Member]

Hi,

Seems like access issue from Designer. Were you able to ping the DB server from the designer machine?

Arun

[former_member203645]

Hi Arun,

Were you able to ping the DB server from the designer machine?

Yes , I can able to access the DS server and query against the Local Repository.

[Former Member]

Hi,

So this is a DB2 server?

Arun

[former_member203645]

yes right

[Former Member]

I think this has to do with the profiles. You have to update the user profile to execute the DB2 profile. If you have not updated the user profile then you won't be able to access the DB2 though executable binaries are present.

[former_member203645]

When you say user profile, Is it CMC ??

[Former Member]

No all related to your DB2. This seems to be a database installation and admin issue.

[former_member203645]

I will check and let you know.

[Former Member]

check the AL_MACHINE_INFO table in the database and check the value that is stored in RESERVED2 column where SERVER_NAME is RepoManager, Designer will use this to connect to the Database

if this value is incorrect fix that remove the repo from CMC and add again

are you using Designer on the same machine as RepoManager ? if RepoManager works then I would expect the Designer to work too on that machine

[former_member203645]

I verified both RESERVED2 AND  SERVER_NAME..................RESERVED2 shows my repository name and SERVER_NAME shows as Administrator.

I deleted and recreated the repository and below is the error message I see when I try to login.

I queried the version and it shows as 14.2.1.0000

[former_member203645]

Any inputs please ???

[Former Member]

When you say query means you are trying to login to designer? Exactly at what instance you are getting this error?

[former_member203645]

I see the error during logon.

I can able to queries the table on my local machine by using query tools like DBsolo,Rapidsql

[Former Member]

Do you have a AL_Version table in repo?

[former_member203645]

I queries my local repository schema :

SELECT * FROM XXXXXX.AL_VERSION

14.2.1.0000

[Former Member]

the error message is showing XXXX.AL_VERSION is the value of XXXX correct ?

[former_member203645]

yes that is correct .... XXXX is my local repository name... For security purpose I mocked up.