RDBMS code 507: CLI2

[srini.dw]

Hi,

We are getting weird issue today, please check the below error

LKUP,0: [IIS-CONN-TERA-005003] RDBMS code 507: CLI2: BADLOGMECH(507): Requested logon mechanism is not available. (CC_TeraConnection::connect, file CC_TeraConnection.cpp, line 796)

All jobs are not getting aborted, few jobs are getting aborted with the above error.

Any one has any suggestions/advice please let me know.

Thank You,

[chulett]

What did your DBA say?

[srini.dw]

DBA does not say anything, he is waiting for my response.

Thank you.

[chulett]

It's a database error, how can they have nothing to say on the subject?

[srini.dw]

Probable Cause:
Insufficient sessions available on the DBS for the FastLoad or MultiLoad job to connect all sessions. The database returns error 8024, but CLI erroneously returns the 507 error, instead of 8024. This problem is recorded in DR 123602. Note that once the DR is fixed in TTU 13, the problem can still occur because of the way FLoad and MLoad calculate the number of sessions to connect; the DR merely corrects the error message which is returned.

I got this from knowledge base.

My question is TD Connector stage with Immediate option uses any utility?
Like TD connector stage with Bulk load uses Fastload, Multiload and Tpump.

Thank you.

[palmer.caleb]

I am currently experiencing this same issue as well using the Teradata Connector stage with the "Immediate" option selected which should use CLIv2. As I understand it, TDC with immediate option does not use any Teradata utilities.

Does anyone have any ideas about this?

Thanks

[TeradataDICoE_MRR]

Sorry I wasn't on here earlier - but immediate mode does NOT consume a Teradata utility. Looks like this has been resolved since there are no recent updates - curious what the solution was?

Thanks,
Mike R.