Results 1 to 9 of 9

Thread: Pastel Partner Runtime Error 2147217887

  1. #1
    New Member
    Join Date
    Jul 2022
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Partner Runtime Error 2147217887

    Hi Guys

    I have had this before around 4 or 5 years ago and Pastel logged on to repair some incorrect number input I think

    Not sure how to repair this. Only happens on the 1 company.

    Any helpful ideas?

    Thanks in advance

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,763
    Thanks
    44
    Thanked 452 Times in 397 Posts
    The error occurs when there is a table with invalid date. This usually occurs when you trying to access the Explorer.

    You can disable the Explorer for the user getting the error. You can do so whilst logged on the company with a password that does not give the error and has access to Setup Users and Passwords. To set the user to use Navigator go to Setup…Users / Passwords…Users, select the correct user and untick "Auto Invoke" for Navigator.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    New Member
    Join Date
    Jul 2022
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Neville, but it does it on all users? and only on 1 company. I have tried all the users

  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,763
    Thanks
    44
    Thanked 452 Times in 397 Posts
    There's a possibility that the database contains an invalid date, which would need to be fixed with a database editor.

    Can you send me a backup of the company so that I can have a look at it? Once I have figured out where the problem is, we can make arrangements for me to fix your live database.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    New Member
    Join Date
    Jul 2022
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Neville

    Dropbox Link ok for the file?

  6. #6
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,763
    Thanks
    44
    Thanked 452 Times in 397 Posts
    Yes, that will be fine.

    Please let me know the password as well.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  7. #7
    New Member
    Join Date
    Jul 2022
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sent

    Password on the link

    Thanks in advance

    Regards
    Colin

  8. #8
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,763
    Thanks
    44
    Thanked 452 Times in 397 Posts
    Hi Colin,

    Which version of Pastel are you using?
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  9. #9
    New Member
    Join Date
    Jul 2022
    Location
    Johannesburg
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Version 14

Similar Threads

  1. [Question] Pastel runtime error 380
    By Sandz1957 in forum Accounting Forum
    Replies: 0
    Last Post: 24-Jun-20, 12:53 PM
  2. [Question] Pastel runtime error 6 overflow
    By David Irish in forum Accounting Forum
    Replies: 1
    Last Post: 15-Mar-17, 01:33 AM
  3. Pastel Runtime error 380
    By Tinashe.Tee in forum Accounting Forum
    Replies: 2
    Last Post: 29-Dec-16, 01:36 PM
  4. [Question] Sage Pastel V12: Runtime Error '401'
    By Anne in forum Accounting Forum
    Replies: 2
    Last Post: 18-Mar-16, 10:31 AM
  5. [Question] Pastel Partner - Runtime Error 9 when running customer statements
    By J7J in forum Accounting Forum
    Replies: 0
    Last Post: 15-Aug-11, 09:45 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •