Hello!
I am trying to use the PARTITION component (using “graphPartition.grf” as example) to load a database table but it is not working. The strange part is that I get no errors: no record are loaded into my database table. This is what my graph looks like
<?xml version="1.0" encoding="UTF-8"?>
…
Has anyone been able to use this component with success against a database table? Please note that my example above works successfully if I output to a set of files (again…using “graphPartition.grf” as example) instead of a database table.
Is using this component against a database table not supported? I welcome any help and/or suggestion. Thank you.
Alan.
Hello Alan !
Your set up of Partition component suggests three intervals - ie. three output edges should be connected:
*first interval …3>
*second interval (3…5>
*third interval (5…
see following example:
******
data/employees.dat
3;5
EmployeeID
******
David.
Hello Alan !
This is very strange in deed ! If you see data coming out of trash, it means that PARTITION component sends them out.
One thing I noticed - you are sharing the same DB connection among all DB_OUTPUT_TABLE. Try to use “threadSafeConnectio” option or simply create three DBConnections and allow each DB_OUTPUT_TABLE to use its own - simply copy&paste the one you have now and specify different name/id for each.
Also send me the original graph tracking output (with logging configured to output even DEBUG ingo) to david.pavliscentrum.cz
David.
David,
I understand what you are saying. I changed my graph as per your email:
<?xml version="1.0" encoding="UTF-8"?>
…
ZERO ROWS are loaded to my target table and I got NO ERRORS…BUT…Using TRASH output as option (instead of database table) works very well.
Does this mean that the PARTITION component is not able to work when connected to a DB_OUTPUT component?
Thanks in advance for your advice.
Alan.