Skip to Content
0

Getting some Error in when trying to acces FMS

May 28, 2017 at 09:43 AM

44

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers