Optional feature not implemented

dataservices job design
1

error message for operation : <[Microsoft][ODBC SQL Server Driver]Optional feature not implemented>.

error message for operation : <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account.

Upgraded (repo) from 14 - 14.2
Straight load to db table. but some tables getting loaded.

Any info about these?

Thanks

n78882 :us: (BOB member since 2010-09-17)

2

Even I am facing the similar issue. After changing date to datetime also some of the tables are throwing the below error

4768 2768 DBS-070401 5/6/2014 12:49:08 AM ODBC data source <> error message for operation : <*****>. This message contains some internal
4768 2768 DBS-070401 5/6/2014 12:49:08 AM system details which have been hidden for security. If you need to see the full contents of the original message, ask your
4768 2768 DBS-070401 5/6/2014 12:49:08 AM administrator to assign additional privileges to your account.

pavani_yerra (BOB member since 2010-04-28)

3

We had the same issue and to fix it, the user reviewing the log has to be granted the “View internal information in log” right (Application --> Data Services Application). We had set up a custom access level that didn’t include that right, and once we added it, this issue displaying <*****> went away. Hopefully that helps!

EZButton (BOB member since 2014-03-27)

4

Refer - http://sap-note.com/1923264.htm

Alternatively, to quickly view the error message, locate the error log file say, <error_sasdad123_12_.txt> in the job server and view the complete message. This is a new security feature added from DS4.2

superkents (BOB member since 2009-03-02)

5

Hello guys,

my situation is this…

the user which runs the job is called svc_bobatch

this svc_bobatch is in the Group of Administrators

I have granted this “View internal information in log” to the Administrator Group

But it doesnt work.

If I check how it looks the rights for Administrators, I see the “View internal information in log” granted…but Source is GRANULAR (Instead of Full Control)

How can I do to make it Full Control?

Thanks!
:nopity:

Victor_BCN :es: (BOB member since 2009-09-15)

6

Hi,

Everything here and in the SAP note says to change the right in the CMC, but where in the CMC? I can’t see this under Data Service under applications or on the user security of the Repositories.

Vague Kbases like that shouldn’t be allowed!

I’m using DS 4.2 SP4 BTW.

Cheers,
Kevin

KevNZ (BOB member since 2014-01-13)