Lompat ke konten Lompat ke sidebar Lompat ke footer

Dynamics Gp This Login Failed Attempt to Log in Again or Contact Your System Administrator

You receive an error message when you try to access, to enter, to save, to print, or to post transactions in the Sales Transaction Entry window in Microsoft Dynamics GP

When yous try to access, to enter, to save, to print, or to postal service transactions in the Sales Transaction Entry window in Microsoft Dynamics GP, you receive one of the post-obit error letters:

A become/change operation on tabular array <table_name> failed accessing SQL data

A get/change operation on table 'SOP_HDR_WORK' failed accessing SQL data

A become/change functioning on table 'SOP_LINE_WORK' failed accessing SQL data

A relieve operation on <table_name> cannot find the tabular array

A remove operation on <table_name> failed accessing SQL data

A become/change performance on tabular array 'SOP_HDR_HIST' failed accessing SQL data

Note The <table_name> placeholder represents the actual table name.

This trouble occurs if a Sales Guild Processing table contains damaged or duplicate records.

To resolve this problem, follow these steps.

Run the Bank check Links procedure

  1. On the Microsoft Dynamics GP menu, point toMaintenance, and so click Check Links.
  2. In the Series list, click Sales.
  3. In the Logical Tables list, click the table that appears in the mistake message that you lot received.
  4. Click Insert, then click OK.
  5. If you are prompted to print the Mistake log, select a destination, and then click OK.

    Annotation For more information near table names, employ the Resource Descriptions window. To open the Resource Descriptions window, bespeak to Resource Descriptions on the Tools bill of fare, and then clickTables.

  6. Perform the activeness that caused the error message that you received.

If you still receive the error message, follow these steps.

Re-create the machine process

  1. On the Microsoft Dynamics GP card, point toMaintenance, and so click SQL.
  2. In the Database list, click the company database, and then click the motorcar procedure that you want to re-create.
  3. Click to select the Drop Car Procedure and Create Motorcar Procedure check boxes, and and so clickProcedure.
  4. Perform the activeness that acquired the fault bulletin that you lot received.

If you lot all the same receive the error message, follow these steps.

Re-create the table

To re-create the tabular array without deleting records that are in the table, use the Toolkit. The Toolkit is a tool in the Professional Services Tools Library.

For more information near the Professional Services Tools Library (PSTL), employ i of the following options:

Customers:
For more information about PSTL, contact your partner of tape. If you do not have a partner of record, visit the following spider web site to identify a partner: Microsoft Pinpoint

Partners:
For more information about PSTL, visit the following web site:

https://mbs.microsoft.com/partnersource/downloads/releases/noam_pstl.htm

To re-create the tabular array, follow these steps:

  1. Get out Microsoft Dynamics GP.
  2. Support the Microsoft Dynamics GP code folder.

    Notes

    • By default, the Microsoft Dynamics GP code folder is in the following location:

      C:\Plan Files\Microsoft Dynamics\GP

  3. Install the Professional person Services Tools Library.
  4.  Commencement Microsoft Dynamics GP.
  5. When you are prompted to include new lawmaking, click Yes.
  6. Add the Professional Services Tools Library to the Shortcuts expanse. To do this, follow these steps:
    1. In the Shortcuts area, click Add, and and then click Other Window.
    2. Aggrandize Technical Service Tools, expand Project, and then click Professional Services Tools Library.
    3. Click Add, and and then click Washed.
  7. In the Shortcuts expanse, click Professional person Services Tools Library.
  8. When y'all are prompted to enter registration keys, click Abolish.
  9. Click Toolkit, and then click Side by side.
  10. Click Recreate SQL Objects, and so click Next.
  11. In the Series list, click Sales.
  12. In the Table list, click the table that appears in the error message that you received.
  13. Click Recreate Selected Table, click to select the Recreate information for selected tabular array(s) check box, and then click Perform Selected Maintenance.

    Note If the table has a custom trigger, yous must manually re-create the trigger.

  14. Perform the action that caused the fault message that you received.

If you lot all the same receive one of the error messages that is described in the "Resolution" section, try these troubleshooting suggestions.

  • Create a Dexsql.log file, and so locate the error message that you received in the Dexsql.log file. The data that comes earlier the error bulletin may aid you determine the cause of the error bulletin.

    For more information virtually how to create a Dexsql.log file, click the following article number to view the commodity in the Microsoft Knowledge Base:

    850996 How to create a Dexsql.log file for Microsoft Dynamics GP

  • Make up one's mind whether the error message that yous received is caused by a particular written report. For case, if yous receive the error message only when you print a particular order or invoice study, the problem may exist acquired past this written report. In this situation, restore the Reports.dic file from a backup copy.

    Notes

    • By default, the Microsoft Dynamics GP Reports.dic file is in the following location:

      C:\Program Files\Microsoft Dynamics\GP

  • Determine whether the error message that you received is caused by a modified report. To do this, print the original study. If you do not receive the error message when you impress the original report, copy the Reports.dic file.

    For more information about how to re-create the Reports.dic file, click the post-obit article number to view the commodity in the Microsoft Noesis Base of operations:

    850465 How to re-create the Reports.dic file in Microsoft Dynamics GP

  • Determine whether the error bulletin that you received is caused past a particular user ID or workstation. To do this, start Microsoft Dynamics GP on a different workstation. Log on past using the user ID that was used when you received the error bulletin. If y'all practice not receive the error message, reinstall Microsoft Dynamics GP on the workstation on which you received the error message. If you do receive the mistake bulletin on some other workstation, the problem may be caused by the user ID. In this situation, create a new user ID.
  • Determine whether the error message that you received is caused past a particular certificate number. If y'all receive the error message only when you lot utilize a particular certificate number, delete this document number. Then, reenter information technology.
  • If you lot imported the data, manually enter a document in the Sales Transaction Entry window. If you do non receive the error message, the trouble may be acquired past the import procedure.
  • Determine whether the error message that yous received is acquired by a customization or by a third-party product. To practice this, disable the customization or the third-party products.
  • Verify that the Open Database Connectivity (ODBC) data source on the workstation is set upward correctly.
  • Determine whether the table contains damaged information. To do this, run the following argument in SQL Query Analyzer. Then, verify the records that are returned.
                        Select  * from <table_name>                  

    Annotation The <table_name> placeholder represents the bodily table name.

For information most technical support for the products that are discussed in this article, visit the following Microsoft Web site:

About nijamkhan

I am simple Hardworking,and i would like improve the Knowledge fourth dimension by time

This entry was posted in Uncategorized. Bookmark the permalink.

woodardtholdrect.blogspot.com

Source: https://nijamkhan786.wordpress.com/2015/08/17/you-receive-an-error-message-when-you-try-to-access-to-enter-to-save-to-print-or-to-post-transactions-in-the-sales-transaction-entry-window-in-microsoft-dynamics-gp/

Posting Komentar untuk "Dynamics Gp This Login Failed Attempt to Log in Again or Contact Your System Administrator"