[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Corrupted user id passed to iSeries ODBC connection from scheduled agent

Posted on 2006-05-19
17
Medium Priority
?
1,996 Views
Last Modified: 2013-12-18
We have LS:DO code which has been running for years which connects to an iSeries using an ODBC driver.
We recently moved the code to a new domino server.  As for as we can tell the config is identical.
However the connection is now failing with "User does not exist". The user specified has the first character of the name missing.  I have put in print statements to prove we are passing the right id.

The agent works perfectly if run from a client or event as a run on server agent,  but when scheduled we get this error.

We tried a different user id and a character from the middle of the id was blanked out.

Any help/advice much appreciated
0
Comment
Question by:MLittlewood
  • 6
  • 5
  • 4
  • +1
16 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16717180
Did you enable ODBC logging, to find out what data is passed and what generates the error?

What O/S is the Domino server running on? What Domino server and Notes releases do you use?
0
 

Author Comment

by:MLittlewood
ID: 16717739

Yes:  IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=8001 - CWBSY0001 - User  UNNINFO on server [blah] does not exist, Password length = 8, Prompt Mode = Never, System IP Address = [blah]

The user passed was actually GUNNINFO but is being received as  UNNINFO  (with a leading space)

when we tried a different id GUNNINFORM  it was passed as GUNNINF RM  with a space in the middle.

The server is 6.5.3  and running on windows 2000 SP4.
I am currently looking into a possible mismatch between the release level of the ODBC driver and client access on the iSeries
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16718435
You're also loggin locally, on the Domino-server? Or are source and destination server one and the same?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:MLittlewood
ID: 16718542
The destination server is separate.  It is an iSeries (AS/400). The domino server is running on Windoows 2000.  Thanks for your help.  
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16718606
So which log says that one letter is missing, the one on the iSeries or the one on the Domino server? Or do they both say the same?
0
 

Author Comment

by:MLittlewood
ID: 16718931
They log on the domino server. I can't find any related errors in the iSeries log just an entry for attempting to process the signon request for UNNINFO
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16719205
0
 
LVL 18

Expert Comment

by:marilyng
ID: 16719376
Please check the DSN configuration again on the iSeries.  So there is a DSN configuration on the iSeries, and an ODBC connection on the client or domino server?  

I've run into a few cases where I need double authentication and the odbc port enabled on the firewall before it would work.   Even though the Domino ID was correct, if you're getting a failed login  with no corresponding error on the Domino log, then it's not domino failing you, its your Active Directory, server permissions and ODBC Port permissions.
0
 

Author Comment

by:MLittlewood
ID: 16719553
Thanks I am getting an error on the Domino log,  but only when running from a scheduled agent,  not when run directly or even as a runonserver agent
0
 
LVL 18

Expert Comment

by:marilyng
ID: 16720917
Ah, then the user Id needs to have permission to run unrestricted agents.  If you set your events.nsf to capture agent errors, you will see the exact error on the Domino side.  Most of the time it is because the userID needs to have permission to run unrestricted agents (that access the file structure) on the server.  Go to server documents: security section, and make sure that the user ID is added to the appropriate agent permissions.  If the Id is misspelled, then recreate the ID using the same name (tell it not to recreate the mail file, if that is a problem.  I usually create one ID just to do these things).

If you're not logging agent errors, then you need to turn these on so you can see them as they occur.  
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16721907
I think I have to agree with you that it must be some version conflict. Did you already try to re-install the ODBC drivers?
0
 
LVL 18

Expert Comment

by:marilyng
ID: 16722708
Just a sidebar, when running manually or runonserver, the agent uses the current user's permissions.   Scheduled, it's using whoever signed the agent, to run on the Domino server, plus whoever is configured in the Domino Server's ODBC  DSN configuration (Advanced Options) for the login name and password.  When you configure the system ODBC, you can test the connectivity.

0
 
LVL 18

Expert Comment

by:marilyng
ID: 16744264
so how are we doing?
0
 

Author Comment

by:MLittlewood
ID: 16749008
Hi,  Sorry for the delay replying.

Unfortunately,  the agent is signed by the domino administrator which is the same ID that I am using to run it manually.

I tried replacing the ODBC DLL,  but that caused an error,  I am going to try and reinstall the drivers properly.

Thanks for all your input.
0
 

Author Comment

by:MLittlewood
ID: 16932690
We got a workaround, though not a solution to this issue by reducing the size of the user id to 5 characters
0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16949170
PAQed with points refunded (500)

GranMod
Community Support Moderator
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

865 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question