topic Re: SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary membe in Administration and Deployment

SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary member

burchill — Mon, 09 Apr 2018 16:52:31 GMT

I have a relatively simple ODBC connection from R to our SPDS server. I can pull data out from the server - thanks for the prior input. I now have users that want to write data back to the server and I am getting an SPDS_ERROR - writing to the server works but it is very slow. I don't know if the returned error is associate with the speed or if that is another issue.

If anyone can shed some light on what the error means and if there might be a SPDS configuration option to adjust/account for the selection error.

I have attached the program that I am using - note I have reduced the size of the R data frame to a small number of records and fields. It is the sqlSave() RODBC call that returns the error.

Thanks

Re: SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary membe

LinusH — Wed, 11 Apr 2018 17:14:11 GMT

I don't know about the sqlsave operation, but clearly it issues invalid code. DICTIONARY.MACROS doesn't exist in SPDS, so it looks like a Base SAS adoptation.

Re: SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary membe

burchill — Wed, 11 Apr 2018 21:01:08 GMT

Thanks for the quick reply - since error is returned from a generic ODBC call to SPDS (no Base SAS) this must be part of the SAS ODBC driver. We have an update to SPDS (and corresponding drivers) happening this weekend so I post again on Monday if that doesn't resolve the issue.

Re: SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary membe

burchill — Wed, 11 Apr 2018 21:02:40 GMT

I should have said Windows Server 2012, SPDS 5.3, and RODBC 3.3.0.

Re: SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary membe

LinusH — Thu, 12 Apr 2018 03:12:00 GMT

Open a track to SAS Tech support wouldn't hurt in this situation.

Re: SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary membe

burchill — Thu, 12 Apr 2018 13:09:30 GMT

That was my next step - I wanted to see if there was any user experience with this error. The community was helpful in getting ODBC query connection working before.

Re: SPDS and RODBC - with sqlSave() SPDS returns SPDS_ERROR: Parse Failure: invalid dictionary membe

burchill — Wed, 18 Apr 2018 13:16:02 GMT

This has gone off to technical support. The upgrade from 5.3x to 5.4 fixed one of the ODBC issues with client applications crashing after several queries, but this issue still exists. Tech support is looking at this and I will post the follow-up.