Data Service we use is 4.2 SP 1 (Patch 4) is supported to SQL server 2012

[former_member281308]

Hi All,

In  My oraganization using  Data services 4.2 sp1 (patch4 ) is compatible to SQL server 2012

The current version of Data Service we use is 4.2 SP 1 (Patch 4) and our metadata is on SQL Server 2008.

DBA’s are planning to upgrade tcsqlreportsdb (where metadata resides) from 2008 to 2012.

Can you do some research and see if the current version of Data Services is compatible for SQL server 2012.

Thanks,

kris.

[former_member281308]

Hi Dirk,

I am getting below the error . Can you please explain me how to resolve this error?

|Data flow DF_EDS_ADC_MMAP_CLAIMS_IB|Reader FF_EDS_ADC_MMAP_CLAIMS_IB1

OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <'Sheet1$' is not a valid

name. Make sure that it does not include invalid characters or punctuation and that it is not too long.>.

(14.2) 09-27-16 12:34:06 (E) (3420:5192) EXL-300873: |Data flow DF_EDS_ADC_MMAP_CLAIMS_IB|Reader FF_EDS_ADC_MMAP_CLAIMS_IB1

OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <Operation is not allowed

when the object is closed.>.

(14.2) 09-27-16 12:34:07 (E) (4104:5876) RUN-053003: Zero divide error. Divisor is equal to zero.

(14.2) 09-27-16 12:34:10 (E) (4520:3332) EXL-300875: |Data flow DF_EDS_ADC_MMAP_CLAIMS_IB

Could not access Excel file

<//tc-ftp/FTP-Site/test/KKapadia/WR_Conversion/Sprint_8/ADC_MMAP_Claims/Incoming/TEST_OmniSYS_Abbott_Medicare_08_31_2016.xls>

(14.2) 09-27-16 12:34:10 (E) (4520:3332) EXL-300873: |Data flow DF_EDS_ADC_MMAP_CLAIMS_IB

OLE or COM processing error. Please make sure Microsoft Access Database Engine is properly installed: <Could not decrypt file.>.

Thanks,

krish.

[former_member187605]

This is really off-topic. And no need to post twice

[former_member281308]

Hi Dirk,

It will support metadata in sql server 2012

Thanks,

krish.

[former_member187605]

That info is readily available in the DS PAM (Product Availability Matrix) accessible from the SAP ONE Support Launchpad (SAP Emergency Contact Details).

SQL Server 2012 is supported from DS 4.2 SP01.

SQL Server 2012 SP2 is supported from DS 4.2 SP04.

[former_member281308]

Hi Dirk,

Thanks for replaying an email. I have some doubts below the question.

The current version of Data Service we use is 4.2 SP 1 (Patch 4) and our metadata is on SQL Server 2008.Can you do some research and see if the current version of Data Services is compatible for SQL server 2012.

I know the Data services support to SQL server 2012 . what about metadata?

Thanks,

krish.

[former_member187605]

That's what I meant.

According to the PAM, support of 2012 as source and target is from SP03, of 2012SP2 from SP04.