Prepare is not safe during execution of the Instr stored procedure. (Microsoft OLE DB Provider for Analysis Service 2005)

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  July 13, 2012 at 1:49 am

  #392735

  Hello,

  I am trying to import data from cube into OLTP database table.

  My source MDX query contains "Instr" function for filtering data.

  I am getting the below error when the query is parsed.

  The statement could not be parsed

  Prepare is not safe during execution of the Instr stored procedure. (Microsoft OLE DB Provider for Analysis Service 2005)

  Can anyone please help !. It's urgent, got stuck with it now..

  In fact I want to save it as package and schedule as job..

  Thanks in advance.

  Smith.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  July 13, 2012 at 9:27 am

  #1512618

  ... When I put a single filter it works fine... The moment I add "INSTR" function it throws error.

  I also tried to pull all the data without any filter.. Even that also doesn't work.. It just hangs.

  .. I am getting lost now... BTW it's SQL server 2005 64bit standard edition with SP4 (Windows 2003 Enterprise 64 bit)