You’re offline. This is a read only version of the page.
40
Dear all,
I am doing the fresh installation of retail in my PC. So in My PC HQ and POS both are in the Same laptop.
I have done all the basic setup that is require to run the POS. Before open the POS we need to Run the N Job first.. While I am running N job 1070 I am getting error.
Error from SQL for N Job 1070 is error no 32769
Server Msg in SQL for n Job 1070 is Target request handler failed to process target request header: ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. ProcessWriteRequestException: Write request on table:[dbo].[RETAILFUNCTIONALITYPROF
for all your reference below is the error which i extracted from Event viewer for this same N Job 1070
2014.5.8 22:15:9:843 (5036) [1] CCommMgr::HandleException: Target request handler failed to process target request header: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessTargetRequestHeaderException: ProcessTargetRequestHeader failed to execute all write requests. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessWriteRequestException: Write request on table:[dbo].[RETAILFUNCTIONALITYPROFILE] failed to execute. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.RunException: Run() failed while creating temporary table. ---> Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.CreateTempTableException: Query: SELECT TOP 0 [ADDTAXONPRICES],[AGGREGATEITEMS],[AGGREGATEITEMSFORPRINTING],[AGGREGATEPAYMENTS],[AMOUNTDECIMALPLACES],[AMOUNTROUNDINGTO],[APPLYDISCOUNTONUNITPRICES],[AUDITENABLED],[BACKUPTRAININGTRANSACTIONS],[BLOCKEDCLOSEDACCOUNT],[CENTRALTABLESERVER],[CENTRALTABLESERVERPORT],[CURRENCYSYMBOL],[CUSTOMER],[CUSTOMER2],[DATAENTRIES],[DAYSCUSTOMERHISTORY],[DAYSTRANSACTIONSEXISTS],[DECIMALNOTREQUIREDFORMINORCURRENCYUNIT],[DISCOUNTATTOTAL],[DISPLAYSECONDARYTOTALCURRENCY],[ENDOFTRANSACTION],[FLOATINGCASHIER],[INVENTORYLOOKUP],[ITEMNOTONFILE],[LIMITSTAFFLISTTOSTORE],[LINEITEMTAXCHANGE],[MARKDOWN],[MARKUP],[MAXIMUMPRICE],[MAXIMUMQTY],[MAXIMUMSTORETRANSLOG],[MINIMUMPASSWORDLENGTH],[MODIFIEDBY],[MODIFIEDDATE],[MULTIBLEITEMSYMBOL],[MUSTKEYINPRICEIFZERO],[NAME],[NEGATIVEADJUSTMENT],[NEGATIVESALESLINE],[NOTAXUSED],[OVERRIDEPRICE],[PRICEDECIMALPLACES],[PRICEROUNDINGTO],[PRINTXREPORTONTERMINAL],[PROFILEID],[RECID],[REFUNDSALE],[REQUIREAMOUNTDECLARATION],[SALESPERSON],[SALESPERSONMODE],[SECONDARYTOTALCURRENCY],[SENDTRANSACTION],[SERIALNUMBER],[SHOWSTAFFLISTATLOGON],[SKIPTAXONRECEIPT],[STAFFBARCODELOGON],[STAFFBARCODELOGONREQUIRESPASSWORD],[STAFFCARDLOGON],[STAFFCARDLOGONREQUIRESPASSWORD],[STAFFVALIDATION],[STARTOFTRANSACTION],[SUPPORTEDCOUNTRYREGIONISOCODE],[SUSPENDRETRIEVETRANSACTION],[TAENABLEREGISTRATION],[TAXREGISTRATIONNUMBERONRECEIPT],[TENDERDECLARATION],[TRANSACTIONDELETEREMINDER],[TRANSACTIONTAXCHANGE],[TSCENTRALTABLESERVER],[TSCUSTOMER],[TSDATAENTRIES],[TSFLOATINGCASHIER],[TSINVENTORYLOOKUP],[TSRESENDDELAY],[TSSENDTRANSACTIONS],[TSSENDVOIDTRANSACTIONS],[TSSTAFF],[TSSUSPENDRETRIEVETRANSACTIONS],[TSTRANSACTIONRESENDLIMIT],[TSUPDATEREPLICATIONCOUNTER],[VOIDISPRESSED],[VOIDPAYMENT],[VOIDPOSTEDTRANSACTION],[VOIDTRANSACTION] INTO [#dbo_RETAILFUNCTIONALITYPROFILE_8b1fe6f3-a362-4998-ac96-94f4995f165c] FROM [dbo].[RETAILFUNCTIONALITYPROFILE]; ---> System.Data.SqlClient.SqlException: Invalid column name 'APPLYDISCOUNTONUNITPRICES'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.CreateTempTable(SqlConnection connection, SqlTransaction transaction) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.CreateTempTable(SqlConnection connection, SqlTransaction transaction) at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlWriteRequestRunner.Run(SqlConnection connection, SqlTransaction transaction) at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessWriteRequest(SqlConnection connection, SqlTransaction transaction) at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader) --- End of inner exception stack trace --- at Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlTargetRequestHandler.ProcessTargetRequestHeader(ISCTargetRequestHeader targetRequestHeader) at CCommMgr.ProcessTargetRequest(CCommMgr* , basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* r_file_path, SCComponentManager scComponentManager)
can any one of your brilliant people help me to solve this issue..
If any one wantto have more information I have the temp file, work folder along with log file and log folder also which i can share if anyone want to see that also.
Thanks in anticipation of reply from all you expert people...
Thanks
Abhijeet...
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
