Skip to Content
avatar image
Former Member

Getting some Error in when trying to acces FMS

Dear Experts

I have 2 db ,1. SAP B1 9.2 (Standared)

2. HCMOne for Payroll (Provide by my Partner)

now come to the issue.

my all employee details are recorded in 2 db (HCMOne for Payroll), and i had created a query like this

------------------------------------------------------------------------------------------------------

Use [HCMOne]

select isnull(MstEmployee.firstName,'')+' ' +isnull(MstEmployee.middleName,'')+ ' '+isnull(MstEmployee.lastName,'')AS [Employee Name] from MstEmployee Where MstEmployee.FirstName <> 'First' and flgActive = '1'

--------------------------------------------------------------------------------------------------------------

and i had used this querry in SAP B1 (Standared) and saved it as QUERY under querry manager and then i had called this query in PO(Purchase order) using FMS

when i try to select any employee in the first line of the PO it is selecting , but after that when i try to add another employee to second line, its hitting an error. also SAP is getting hang and the Querry manager is Showing blank after that

am getting this errors:

1. [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'dbo.CSHS'. 'User-Defined Values' (CSHS) (CSHS)


2. (-2004) Critical cache refresh failure


Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers