Clarion Error 6
Reginald Hanfy
Is there a way to suppress the File Access Error Message and the subsequent Halt when the application is unable to open a SQL Table? I would like to grab the error and allow the application to either continue without opening the table or gracefully shutdown.
Let me give you a little background on the situation. We use Clarion 6 and we handcode, we do not use ABC templates. We are wanting to migrate from .dat/tps files to MSSQL. The current .dat/tps tables are in use 24/7 (manufacturing plants). We want to write to both the .dat/tps files and the MSSQL tables at the same time as the first step in this transition.
In order to generate feedback but not cause the panic, I am logging any error that is received, setting a global variable and if the global variable is set to false than the code that writes to the tables will not attempt to write to MSSQL. All of this is working.
Hi Cindy
In my experience, errors in prod that are ok in test is almost always security permissions of one form or another.
Unfortunately with SQL the possible causes are legion and restricted to your site.
Cindy,
Just to let you know, the error that I get comes from the ABC File Manager class. This occurs when I do Access:Table.Open or Access:Table.TryFetch. According to some people that I have talked to, the only way to suppress this error is to modify the File Manager class, which I do not want to do. What I have done is write a small C# program that I call SQLPing and test the Database connection prior to performing the Open or Fetch, and if the Ping fails then I do my error handling.
I have been able to get an agreement with the manufacturing IT to run our application on an unused machine in production tonight in order to receive accurate feedback. If that falls through, then I guess I am going to write up a web service and make a call to it.
Suppress Clarion messages until after the Clarion connection has been done, by using something like systemPROP:MessageHook = address (MyMessage) where MyMessage is your own function to trap Clarion messages. The Clarion help has a good description of this.
Sounds like a bug in clarion to me. Should be reported.
Many years ago in C6 I had a problem where the driver would very occasionally use the wrong driver string for ODBC tables and pick the wrong DB.
I know this is an old thread, but want for completeness just add what I think.
Consider that the file NewExtents is closed the second time you going into it.
Your code structure only traps an error after the next which breaks out on any error. So it it might just be that the file is not open. You might have badly nested open and close statements can also be from previous calling procedures.
Morning all,
My factory fitted clarion CD changer is showing the "Invalid Disc Error" on all discs.
Several forums including FFRR report that hitting the unit can fix the error permanently. In fact this seems to be the widely adopted way to fix this error. Alas, I thought I could master this technique, but I have been unable to find any specific guidance on where to hit the unit.
My unit it fitted into the upper glove box with a housing surrouding it to make it fit the glove box neatly. As per the image below, nicked from another users post:
It seems a bit pointless to hit this unit on the front - the sliding door is likely to absorb most of the impact, I tried a couple of taps, and then took out the cartridge and gave that a slap too. Clearly I am doing this wrong.
So, can anyone help me please? How and where do I whack it?
Thanks
Mark
Hi Stan,
thanks for the reply. I do want to try tapping it properly first, and tapping at the front doesn't seem to impact the actual unit, just the sliding door.
So, am looking for someone who has had success with this to explain what they did to their unit to get it working again.
If needs must, a replacement unit will be bought, but first I want to tap it. Somewhere i read about someone using a rubber mallet and giving it a real whack. Elsewhere, someone tapped the cassette. Both worked.
Cheers
Mark
Stan- so true.
Dave, might be worth a shot. Advice is generally that the lens of the laser shouldn't be touched by anything other than a proper cleaning disc - precision optics. Not sure how I would get either cotton bud or leather onto the lens. I assume the discs are fed in from left to right inside the housing. Might make it tricky to get access. I'll have a look later and order a cleaning disc if i don't have one.
I can't remember the last time I used a CD in a car, I think it was loading some music onto the HDD in my 2009 5 series.
Sorry, just made me think... Back on topic, I do agree that a cleaning disc is the best place to start, MY23 Panamera E-Hybrid
MY19 SDV8 Autobiography - Sold
Well I started life as a Walkman repair engineer and have a life time of experience in fixing everything else including cd players , tv and video, audio and radio plus much much more I dont want to bore you with.
A cd cleaning disc doesn't actually touch the laser lense so doesn't clean anything I assure you my method is an industry excepted method an 99% of the time works. Sometimes the laser can fail but not often.
Strip it out access the laser lense give it a clean make sure there is no residue on the lense it's just dirty and failing to focus
Thanks guys, I appreciate all the input. I'm going to start by using a compressed air hose at my local garage this morning and give it a blast, if that doesn't work then will consider Dave's advice on dismantling and cleaning, and finally if that doesn't work either a replacement or a swap out.
Whilst I appreciate that CDs are an old format, it is one I still like. MP3 could have it's place in my life and that would only be in the car. I would quite happily swap out the changer for a HDD based MP3 storage if there is an easy way to do this - haven't looked into that yet.
It is not often I have a month or two where there is not some small job to do on the FFRR, but so far so good.
As Dave has mentioned, cleaning with a cotton bud is the best way to go. Take the unit out and open it up. The lens is easy to spot. I've cleaned a few in my time with a bit of alcohol cleaner on a cotton bud, gently wipe it over the lens, allow to evaporate and use the dry end of the cotton bud to polish the lens after. No need to press down hard, just gently wipe the surface. 2011 TDV8 Vogue SE
Error 1.Battery inside CD Changer needs to be replaced.
Error 2.CD error message. Mechanism has as eject problem or takes a long time to select CD.
Error 3.CD error message. The pick-up is out of focus during play mode due to scratches on the disc or contamination.
Error 4.Connection problem. Reconnect the data cable.
Error 5.CD error message. Could not read correct data due to CD ROM.
Error 6.CD error message. Could not read data from disc because it is upside-down.
Error 8.Tape Drive system defective. Eating tape or something wrong with the drive system.
Error 9.Weak RF. Try alternate frequency
NO CD.CD error message. No CD is magazine or no magazine in CD Changer.
There are several methods to set the clock, depending on the model.
Method 1
Press and hold the BAND and DISPLAY buttons to display the clock
Press and hold the BAND and DISPLAY buttons until the time display flashes
SEARCH left to adjust the hours; right to adjust the minutes
Press BAND button to store the time
Method 2
Same as Method 1, except press DISP to store the time
Method 3
Press ADJ
SEARCH left or right to select clock and press ENT
SEARCH left or right to select the hour or minute
Turn rotary knob clockwise or counter-clockwise to set the correct time
Press enter to store the time
Press ADJ to return to the previous mode
Method 4
Press and hold the BAND and FUNCTION buttons to display the clock
Press and hold the BAND and FUNCTION buttons until the display flashes
Search left to adjust hours; right to adjust minutes
Press BAND button to store the time
Method 5
While the display is showing the clock, press and hold the CLOCK knob until the minutes flash
Press the CLOCK knob to adjust the minutes
When the CLOCK knob is released for 5 seconds, the hours will flash
Press the CLOCK knob to adjust the hours
When the CLOCK knob is released for 5 seconds, the time will be stored
The tone controls are automatically disabled if you have our DSP/Crossover module connected or the Z-Enhancer enabled. If not, press and hold the BAND and PRESET #3 buttons, or the BAND and RANDOM buttons
I'm opening the only Dictionary file that exists, clicking on the table
I want to modify then clicking on Field/Keys, add the new field, click
Close. Then I right-click on the table, choose Browse, I then get the
warning that the file layout doesn't match the physical file so I tell
it to modify the file, verify I can see the new field, then Save and
Exit the Dictionary file. But when I go to run the APP, I receive the
"Invalid Record Declaration (47)" error.What's interesting is that if I delete the TPS file and run the APP, it
re-creates the TPS file with the original layout - minus the new field.
I don't understand where it's getting the file layout information.I removed all other Dictionary files with the same name from other
folders (there were a number of older copies on the development
computer). I removed all INI files and disconnected the computer from
the network where the production files are stored. The whole
application consists of one EXE and a number of DLL files. I've re-
compiled the main EXE and the called APP/DLL where the Browse call is
stored but no go.Somehow, the compiled code is getting the file layout from somewhere but
I can't seem to figure it out. I've even renamed the DCT file to an XXX
file temporarily and the system was still able to recreate the orignal
TSP file with the original field list.Any and all help would be greatly appreciated!
Wade