Database Errors

Collapse
X
Collapse
 
  • Page of 3
  • Time
  • Show
Clear All
new posts
Previous 1 2 3 template Next
  • tsbservice
    Field tech

    Site Contributor
    5,000+ Posts
    • May 2007
    • 7951
    #16
    Re: Database Errors

    Originally posted by Aneurysm
    OK I found something, working much better for me now, how is it on everyone else's end?
    It works now. Thanks for your time and much needed input. Keep up the good work.
    A tree is known by its fruit, a man by his deeds. A good deed is never lost, he who sows courtesy, reaps friendship, and he who plants kindness gathers love.
    Blessed are they who can laugh at themselves, for they shall never cease to be amused.

      Comment

      • guitar9199
        Service Manager

        Site Contributor
        1,000+ Posts
        • Sep 2016
        • 1099
        #17
        Re: Database Errors

        Originally posted by Aneurysm
        OK I found something, working much better for me now, how is it on everyone else's end?

        I'm in!! Thanks brother!!

        Have a Happy Thanksgiving!

          Comment

          • NeoMatrix
            Senior Tech.

            2,500+ Posts
            • Nov 2010
            • 3514
            #18
            Re: Database Errors

            The database purge appears to have worked.

            Re. Database fault.
            Was it a temp table dataset(AKA dead file) that didn't merge with the primary database?
            Maybe semaphore flag holding the primary data set locked?
            Could it be duplicate primary key or out of range variable fill with corrupt characters?
            Corrupt data can prevent the main database from updating.

            It appears you have fixed the fault, well done....
            Inauguration to the "AI cancel-culture" fraternity 1997...
            •••••• •••[§]• |N | € | o | M | Δ | t | π | ¡ | x | •[§]••• ••••••

              Comment

              • Synthohol
                Certified Konica Expert

                Site Contributor
                5,000+ Posts
                • Mar 2016
                • 5777
                #19
                Re: Database Errors

                YAYYYYYYYYY!!!
                We know a thing or two because we've seen a thing or two.
                The medication helps though...

                  Comment

                  • 20 year tech
                    Senior Tech

                    500+ Posts
                    • May 2014
                    • 577
                    #20
                    Re: Database Errors

                    Originally posted by Aneurysm
                    OK I found something, working much better for me now, how is it on everyone else's end?
                    working like it should, well done thank you

                      Comment

                      • driving lots of miles
                        Trusted Tech

                        250+ Posts
                        • Jun 2016
                        • 396
                        #21
                        Re: Database Errors

                        working normal now even the new posts button is working again.
                        thanks!

                          Comment

                          • copyman
                            Owner / Technician

                            Site Contributor
                            2,500+ Posts
                            • Sep 2005
                            • 4593
                            #22
                            Re: Database Errors

                            Thanks aneurysm. Hopefully it's fixed and you don't have to be messing with this during the holiday weekend!


                            Working great! Seems faster or maybe just because I haven't been able to get on in about a week

                            Happy Thanksgiving to everyone.

                              Comment

                              • Aneurysm
                                Administrator

                                1,000+ Posts
                                • Jan 2005
                                • 1030
                                #23
                                Re: Database Errors

                                Originally posted by NeoMatrix
                                The database purge appears to have worked.

                                Re. Database fault.
                                Was it a temp table dataset(AKA dead file) that didn't merge with the primary database?
                                Maybe semaphore flag holding the primary data set locked?
                                Could it be duplicate primary key or out of range variable fill with corrupt characters?
                                Corrupt data can prevent the main database from updating.

                                It appears you have fixed the fault, well done....
                                One of the tables in the database had a very large chunk of corrupt data, it should have self-corrected but I think due to the size of the bad data it was taking too long to repair and that brought on the timeout errors. Had to fix it from the Server/SQL side, hopefully that will take care of it.
                                "Remain calm. All is well." -Chip Diller, Nov 1963

                                  Comment

                                  • Aneurysm
                                    Administrator

                                    1,000+ Posts
                                    • Jan 2005
                                    • 1030
                                    #24
                                    Re: Database Errors

                                    Originally posted by copyman
                                    Thanks aneurysm. Hopefully it's fixed and you don't have to be messing with this during the holiday weekend!


                                    Working great! Seems faster or maybe just because I haven't been able to get on in about a week

                                    Happy Thanksgiving to everyone.

                                    Seems a little faster to me too
                                    "Remain calm. All is well." -Chip Diller, Nov 1963

                                      Comment

                                      • blackcat4866
                                        Master Of The Obvious

                                        Site Contributor
                                        10,000+ Posts
                                        • Jul 2007
                                        • 22985
                                        #25
                                        Re: Database Errors

                                        Thanks! I was getting worried. =^..^=
                                        If you'd like a serious answer to your request:
                                        1) demonstrate that you've read the manual
                                        2) demonstrate that you made some attempt to fix it.
                                        3) if you're going to ask about jams include the jam code.
                                        4) if you're going to ask about an error code include the error code.
                                        5) You are the person onsite. Only you can make observations.

                                        blackcat: Master Of The Obvious =^..^=

                                          Comment

                                          • slimslob
                                            Retired

                                            Site Contributor
                                            25,000+ Posts
                                            • May 2013
                                            • 37179
                                            #26
                                            Re: Database Errors

                                            Thanks Aneurysm, some of us were starting to worry about you.

                                              Comment

                                              • mansart
                                                Senior Tech

                                                Site Contributor
                                                500+ Posts
                                                • Apr 2009
                                                • 852
                                                #27
                                                Re: Database Errors

                                                Thumbs up.....aneurysm

                                                Now for the "put your money where your mouth is" statement........

                                                Would be nice to see a few new "Contributor" badges

                                                  Comment

                                                  • Zaxxon
                                                    Senior Tech

                                                    500+ Posts
                                                    • Jan 2014
                                                    • 608
                                                    #28
                                                    Re: Database Errors

                                                    Great admin, thanks
                                                    Please start you post with brand, model, problem.

                                                      Comment

                                                      • keithxxiii
                                                        Just a tech

                                                        250+ Posts
                                                        • Nov 2014
                                                        • 468
                                                        #29
                                                        Re: Database Errors

                                                        Awwww Yisssss!!! We're back!
                                                        Aye! Cut the crap

                                                          Comment

                                                          • Phil B.
                                                            Field Supervisor

                                                            10,000+ Posts
                                                            • Jul 2016
                                                            • 22798
                                                            #30
                                                            Re: Database Errors

                                                            Originally posted by Aneurysm
                                                            One of the tables in the database had a very large chunk of corrupt data, it should have self-corrected but I think due to the size of the bad data it was taking too long to repair and that brought on the timeout errors. Had to fix it from the Server/SQL side, hopefully that will take care of it.
                                                            AWESOME Job Brother! Working correctly on my end also!.. will be contributing again!

                                                              Comment

                                                              Previous 1 2 3 template Next
                                                              Working...