OpenSync

Home Forums OpenSync Adding new customer says "Name specified already exists on file"

This topic contains 9 replies, has 2 voices, and was last updated by  Yudel Rosales 4 years, 3 months ago.

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #16904

    Pavel Brun
    Premium Member

    So, it appears there is a database issue. I am trying to add a new customer and using the status of “ADD” but the API says the name exists, which is incorrect. The name doesn’t exist, it is a new customer, but seems to not want to accept this new name.

    Is there anything I can look into to determine the reason for this error?

    Paul

    Attachments:
    You must be logged in to view attached files.
    #16943

    Yudel Rosales
    Keymaster

    Can you post your log files please?

    #16950

    Pavel Brun
    Premium Member

    aa
    20170915.150351 I 5752 RequestProcessor ========= Started Connection =========
    20170915.150351 I 5752 RequestProcessor Request Processor, QBXMLRP2 v13.0
    20170915.150351 I 5752 RequestProcessor Connection opened by app named ‘OpenSync’
    20170915.150351 I 5752 CertVerifier The Authenticode signature validated OK.
    20170915.150354 I 5752 RequestProcessor OS: Microsoft Standard Edition (build 9200), 64-bit
    20170915.150354 I 5752 RequestProcessor Current User is in AdminGroup
    20170915.150354 I 5752 RequestProcessor Current Process Integrity Level : 2000
    20170915.150355 I 5752 RequestProcessor Quickbooks is not running currently
    20170915.150355 I 5752 RequestProcessor Launch a new instance of Quickbooks
    20170915.150356 I 5752 RequestProcessor Getting the IUnknown COM instance of QB
    20170915.150357 I 5752 RequestProcessor Opening the file in the DoNotCare mode.
    20170915.150403 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150403 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150403 I 7888 QBSDKMsgSetHandler QUERY: Host
    20170915.150403 I 7888 QBSDKMsgSetHandler Request 1 completed successfully.
    20170915.150403 I 7888 MsgSetHandler Finished.
    20170915.150403 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150403 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150403 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150403 I 7888 QBSDKMsgSetHandler QUERY: Company
    20170915.150403 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150403 I 7888 MsgSetHandler Finished.
    20170915.150403 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150403 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150403 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150403 I 7888 QBSDKMsgSetHandler QUERY: Preferences
    20170915.150403 I 7888 QBSDKMsgSetHandler Request 1 completed successfully.
    20170915.150403 I 7888 MsgSetHandler Finished.
    20170915.150403 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150404 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150404 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150404 I 7888 QBSDKMsgSetHandler QUERY: DataExtension Definition
    20170915.150404 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150404 I 7888 MsgSetHandler Finished.
    20170915.150404 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150405 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150405 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150405 I 7888 QBSDKMsgSetHandler QUERY: DataExtension Definition
    20170915.150405 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150405 I 7888 MsgSetHandler Finished.
    20170915.150405 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150406 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150406 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150406 I 7888 QBSDKMsgSetHandler ADD: Customer Job
    20170915.150406 E 7888 CustomerStorage::DoAdd The name is already in use: Duntech.
    20170915.150406 I 7888 QBSDKMsgSetHandler Request 1 failed.
    20170915.150406 I 7888 MsgSetHandler Finished.
    20170915.150406 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150406 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150406 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150406 I 7888 QBSDKMsgSetHandler ADD: DataExtension
    20170915.150406 E 7888 DataExtStorage::DoAdd Did not find Customer “”.
    20170915.150406 I 7888 QBSDKMsgSetHandler Request 1 failed.
    20170915.150406 I 7888 MsgSetHandler Finished.
    20170915.150406 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150409 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150409 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150409 I 7888 QBSDKMsgSetHandler QUERY: Customer Job
    20170915.150409 E 7888 CustomerStorage::DoQuery name type mismatch.
    20170915.150409 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150409 I 7888 MsgSetHandler Finished.
    20170915.150409 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150409 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150409 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150409 I 7888 QBSDKMsgSetHandler QUERY: Customer Job
    20170915.150409 E 7888 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150409 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150409 I 7888 MsgSetHandler Finished.
    20170915.150409 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150409 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150409 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150409 I 7888 QBSDKMsgSetHandler QUERY: List Delete
    20170915.150409 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150409 I 7888 MsgSetHandler Finished.
    20170915.150409 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150409 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150409 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150409 I 7888 QBSDKMsgSetHandler QUERY: Estimate
    20170915.150410 E 7888 EstimateStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 E 7888 EstimateStorage::BuildEstimateLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 E 7888 EstimateStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 E 7888 EstimateStorage::BuildEstimateLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 E 7888 EstimateStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 E 7888 EstimateStorage::BuildEstimateLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150410 I 7888 MsgSetHandler Finished.
    20170915.150410 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150410 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150410 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150410 I 7888 QBSDKMsgSetHandler QUERY: Transaction Delete
    20170915.150410 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150410 I 7888 MsgSetHandler Finished.
    20170915.150410 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150410 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150410 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150410 I 7888 QBSDKMsgSetHandler QUERY: Entity
    20170915.150410 E 7888 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 E 7888 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 E 7888 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150410 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150410 I 7888 MsgSetHandler Finished.
    20170915.150410 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150410 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150411 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150411 I 7888 QBSDKMsgSetHandler QUERY: Customer Job
    20170915.150411 E 7888 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150411 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150411 I 7888 MsgSetHandler Finished.
    20170915.150411 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150411 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150411 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150411 I 7888 QBSDKMsgSetHandler QUERY: Customer Job
    20170915.150411 E 7888 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150411 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150411 I 7888 MsgSetHandler Finished.
    20170915.150411 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150411 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150411 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150411 I 7888 QBSDKMsgSetHandler QUERY: Customer Job
    20170915.150411 E 7888 CustomerStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150411 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150411 I 7888 MsgSetHandler Finished.
    20170915.150411 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150411 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 5752).
    20170915.150411 I 7888 SpecVersion Current version of qbXML in use: 13.0
    20170915.150411 I 7888 QBSDKMsgSetHandler QUERY: Item
    20170915.150411 E 7888 ItemServiceStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150411 E 7888 ItemServiceStorage::BuildTheRetObject This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
    20170915.150411 I 7888 QBSDKMsgSetHandler Request completed successfully.
    20170915.150411 I 7888 MsgSetHandler Finished.
    20170915.150411 I 7888 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 5752), ret = 0.
    20170915.150414 I 5752 RequestProcessor Connection closed by app named ‘OpenSync’
    20170915.150414 I 5752 RequestProcessor ========== Ended Connection ==========

    #17017

    Yudel Rosales
    Keymaster

    On the main windows go to File->Options and check “Trace Updates”. Can you post the xml file that will be generated please? post the xml and the log files. Please do not copy and paste the logs.

    #17039

    Pavel Brun
    Premium Member

    Done…..attached are the log files….

    Attachments:
    You must be logged in to view attached files.
    #17096

    Yudel Rosales
    Keymaster

    What does the error table say? are you entering the ListID field?

    #17104

    Pavel Brun
    Premium Member

    It specifies: “Name specified already exists on file”.

    That is it….usually, when I get this error, then it actually means the name exists, but it reality, it doesn’t….anywhere.

    Paul

    #17114

    Yudel Rosales
    Keymaster

    QuickBooks only allows the same name to be used once regardless if it’s a customer, vendor, employee or other name. Can you check that you haven’t entered it please?

    #17122

    Pavel Brun
    Premium Member

    I found the name in the “Vendor” List, I had to look at “All Vendors” instead of just active ones.

    Thanks
    Paul

    #18830

    Yudel Rosales
    Keymaster

    your very welcome. It was good that we figured it out.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic.