i have a probleme of inserting pdf in my sqlserver database by planetpress production ,i checked the connexion to my database in my workflow it's succeed ,but no pdf inserted in my databse when i checked the log i found like:
REQST: PPImage Request - 19:32:04

INFO: Processing file C:\ProgramData\Objectif Lune\PlanetPress Suite 7\PlanetPress Image\QueuedJobs\46634123.ps
DEBUG: Reading job options from input file
DEBUG: Watch Process Name : Documents Retour Clients Direct / SBT PDF
INFO: Starting conversion...
INFO: Initializing PlanetPress Alambic...
INFO: Distilling file to 20406_Recap.pdf...
INFO: Conversion completed successfully.
DEBUG: Moving file to destination folder: \\lmpipp03\d$\Archives\Documents Retour\Clients Direct\20120426
INFO: Adding PDF to database
ERROR: I1009 : Error adding PDF to database : Invalid object name 'Table_Path'
INFO: Process completed successfully.

REQST: End time: 19:32:04
please if some body have the solution let me know.
thanks in advance

Hi Droussi20,

With the information that I have here is that somehow you might have lost the table called “Table_Path” on your database (SQL or Access) used by PlanetPressSearch.
That particular table keeps the information related to the physical path where your PDFs are stored. In other words it’s a pointer to a file location.

I am sure also that the PDFs generated by Image are actually created. Correct me if I’m wrong.

What I would suggest you to do is to verify if you are pointing to the right database under PlanetPressSearch. Check also that your database used by PP Search exists and that the tables are present.

Finally if everything else fails, try rebuilding your database.

Let me know how it went.

Regards,

Julio

Hello,

Just as a reminder, when you get errors like

ERROR: I1009 : Error adding PDF to database : Invalid object name 'Table_Path'

You can note the error ID (here I1009) and lookup our online knowledge base for a generic explanation and possible solution for this error. For example, the kb suggests that this error may be caused by the PlanetPress Image Service not having the proper user rights.


Hope this helps


[edit: corrected link]

Hi again,
yes correct, it's a database probleme,and i solved this by the assistance of a technical support,this is the answer in french:
1. Créer une DB dans SQL server
2. S'assurer que le user et password associés à cette DB, a PlanetPress Search assignée comme DB par défaut
3. Créer un profil SQL dans PPSearch
4. Aller dans optionsUserOptionsSearch Options et configurer la SQL DB à utiliser (user)
5. Aller dans optionsRebuild Database (Ceci créera toutes les tables manquantes dans la SQL DB, incluant la table "table_Path" qui apparait comme manquante dans vos logs d'erreur)
6. Ensuite dans PPWatch, régler les preferences comme d'habitude, pour définir quelle DB à mettre à jour.

thank you all julio,Benoit et Olivier.

For everyone's information, the "Invalid object name 'Table_Path'" error almost always comes from a PPSearch/SQL DB environment that was not setup properly. I have never seen it when using an MSAccess profile.

Using the provided procedure will make sure no steps are missed when configuring a SQL Profile for PPSearch, and will prevent that error. Please note that any missing detail from this procedure will likely cause issues. Here is the procedure in english:
- Create DB in SQL server
- Make sure the credentials used for that DB, have the SearchDB assigned as its DEFAULT DB
- CreateSQL search profile in PPSearch
- Go in options--UserOptions--Search Options and setup the SQL DB credentials to use
- Go in options--Rebuild Database (That will create all the missing tables in the SQL DB, including the famous missing "table_Path")
- Then in watch, setup your preferences as you did before

Hope this helps.
Regards,
Olivier