topic Re: The parameter *pBookmark is invalid for CPage::Load. in Microsoft Integration with SAS

The parameter *pBookmark is invalid for CPage::Load.

jordanw1993 — Fri, 01 Jun 2018 10:09:26 GMT

Hi everyone,

Would anyone be able to explain the following error message a little further as I am unsure what is causing it:

The parameter *pBookmark is invalid for CPage::Load.

-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: System.ArgumentException
Message: The parameter *pBookmark is invalid for CPage::Load.
Target Site: GetRows

Stack Trace:
at ADODB.RecordsetClass.GetRows(Int32 Rows, Object Start, Object Fields)
at SAS.Servers.Dataset.Read(Int32 startRow)
at SAS.OfficeAddin.Rendering.ExcelDataRenderer.RenderSasData(SasDataSource dataSource, Range destination, RenderState state, RenderOptions options, Int32 cachedRowCount)
at SAS.OfficeAddin.ExcelAddin.ProcessDataView(JobContext context, Range destination)
at SAS.OfficeAddin.ExcelAddin.ProcessDataViews(JobContext context)
at SAS.OfficeAddin.OfficeAddinBase.PostProcessJob(JobContext jobContext, Boolean promptOnErrors)

The issue arises when opening a SAS data source.

I'm using SAS Add-In for Microsoft Office version 7.100.0.2122.

Thanks,

Jordan

Re: The parameter *pBookmark is invalid for CPage::Load.

ballardw — Fri, 01 Jun 2018 14:35:11 GMT

What type of SAS "data source" are you attempting to open? Can you show the path/file name?

Triple check spelling and if the source is open or in use by SAS, that might be an issue.

Re: The parameter *pBookmark is invalid for CPage::Load.

CaseySmith — Mon, 04 Jun 2018 16:19:19 GMT

That callstack indicates that you were attempting to open a data set into an Excel sheet, but an error occurred while the Add-in was attempting to read records from the data source. That should not happen. At a minimum you should be given a friendly, helpful error message. I recommend contacting SAS Tech Support.

Casey

Re: The parameter *pBookmark is invalid for CPage::Load.

jordanw1993 — Tue, 05 Jun 2018 08:08:50 GMT

Thanks for the insight, I will get in contact with Tech Support