AnsweredAssumed Answered

Server Script problem

Question asked by JFFortier on Apr 30, 2010

Title

Server Script problem

Your post

Hi

 

I have an issue with a server script It work for a week and yesterday night... It stop working!

The script now is the simple you can get.  (I had a previous version with lots of IF and THEN, GET LAST ERROR.....)


Win 2003, FMS10

 

The script run daily at 8:00pm

 

When I go look in my Documents folder, the file is there, but the modification/creation date is the one from 2 days ago, (when it was still working)

 

WHY WHY WHY ?!?! I remove all the previous get last error.... if... then.. to make it easy to check.... but now it's  simple, and the thing is WHY did it stop exporting ??

the script still run on the server (Server Admin last run OK) I receive the e-mail that the list is OK but no attachment and the export didn't work because the file have the wednesday date on it

 

My script:

 

Allow User Abort [ Off ]
Set Error Capture [ On ]
Go to Layout [ “E_Fiche” (Entretien) ]
Enter Find Mode [ ]
Insert Calculated Result [ Entretien_Data::ED_DateFin_Contrat; "1/1/10...12/12/10" [ Select ]
Perform Find [ ]
If [ Get ( FoundCount )=0 ]
  Send Mail [ Send via SMTP Server; To: "a...@c.com"; Subject: "*** List is empty ***"; Message: "Empty list."; Name: "FM_Serveur"; Email Address: "i...@c.com"; Reply-To Address: "nore...@noreply.com"; SMTP Server: "relais.v.ca"; Port: 25; Authentication Type: None ] [ No dialog ]
  Exit Script [ ]
End If
Go to Layout [ “E_Liste_Renouvellement” (Entretien) ]
Sort Records [ Specified Sort Order: Entretien_Data::ED_DateFin_Contrat; ascending Entretien::E_Numéro_Contrat; ascending ] [ Restore; No dialog ]
Set Variable [ $path; Value:"filewin:" & Get ( DocumentsPath ) & "ppm_expires.xls" ]
Export Records [ File Name: “$path”; Use field names as column names; Character Set: “Unicode (UTF-16)”; Field Order: cr0107_Client::no_client Entretien::E_Numéro_Contrat cr0106_Livraison::adresse1 ] [ No dialog ]
Send Mail [ Send via SMTP Server; To: "j...@c.com"; Subject: "*** List of contract SUCCÈS ***"; Message: "List of contract."; Attachment: “$path”; Name: "FM_Serveur"; Email Address: "i...@c.com"; Reply-To Address: "i...@c.com"; SMTP Server: "relais.v.ca"; Port: 25; Authentication Type: None ] [ No dialog ]

 

 

 

Thank you

JF







Outcomes