RPC error query

Problem : After instollation SQL Express and M.M.7.0 


1. RPC errore while submitting  POS Submit account 
2. Error Message like " MSDTC SERVICES IS NOT RUNNING "


Solution :
1.

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'


Note:  Replace 'myserver' with your servername in the above query.




2. Go to Services (Control Panel-- Administrative Tools--Services ) and then start the service 'Distributed Transaction Coordinator' (MSDTC) with start up type as 'Automatic' and Log On As 'Network Service' as shown in the attachment.   Then execute the below mentioned Query relating to 'RPC' error to solve the problem.

Error Message like " MSDTC SERVICES IS NOT RUNNING "

Go to Services (Control Panel-- Administrative Tools--Services ) and then start the service 'Distributed Transaction Coordinator' (MSDTC) with start up type as 'Automatic' and Log On As 'Network Service' as shown in the attachment. Then execute the Query relating to 'RPC' error to solve the problem.

Run the following query using query analyzer (replace ‘myserver’ with your server name):

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'
go

While doing submit accounts ‘Server not configured for RPC’

Solution:

Run the following query using query analyzer (replace ‘myserver’ with your server name):

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'
go
Note: The above error is related to SQL Server configuration settings and not related to the application. (RPC is Remote Procedure Call).

Delete Duplicate Account Head in Subaccounts

Delete Duplicate Account Head in Subaccounts.

Date format should be = ‘yyyy-mm-dd’

Go to The SQL Query Analyser and run the following command.

Use Subaccounts

EXECUTE [H_DeleteDuplicate] @TransDate = '2010-04-09'

Error while taking Sub office Monthly Report

While taking sub office monthly report an error comes.

Run time error Microsoft odbc sql server driver ' the definition for column money ' must include a data type.

Execute the attached script through script tool selecting treasury database

Download

Adding Account Head Error in Treasury Module

Download and Update this exl file given by PTC,

Download