Issue #11925 has been updated by Avi Miller.
None. I'll take a look to see if I can reproduce this either at or after linux.conf.au next week. ---------------------------------------- Bug #11925: SQL is generated improperly when tied to an Oracle DB https://projects.puppetlabs.com/issues/11925 Author: Jeff Chapin Status: Investigating Priority: Normal Assignee: Avi Miller Category: stored configuration Target version: Affected Puppet version: 2.6.12 Keywords: SQL Oracle Stored_Configuration Branch: I have tied a puppetmaster to an Oracle database, and I am attempting to use stored configs. When running puppet --test for the first time after configuring this, I get the following error: err: Could not retrieve catalog from remote server: Error 400 on SERVER: OCIError: ORA-00907: missing right parenthesis: CREATE TABLE "RESOURCES" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "TITLE" CLOB NOT NULL, "RESTYPE" VARCHAR2(255) NOT NULL, "HOST_ID" NUMBER(38), "SOURCE_FILE_ID" NUMBER(38)(38), "EXPORTED" NUMBER(1), "LINE" NUMBER(38)(38)(38), "UPDATED_AT" DATE, "CREATED_AT" DATE) *note the extra (38) following the type declarations* If I run puppet --test a second time, I get: err: Could not retrieve catalog from remote server: Error 400 on SERVER: OCIError: ORA-00907: missing right parenthesis: CREATE TABLE "RESOURCES" ("ID" NUMBER(38) NOT NULL PRIMARY KEY, "TITLE" CLOB NOT NULL, "RESTYPE" VARCHAR2(255)(255)(255) NOT NULL, "HOST_ID" NUMBER(38)(38)(38)(38)(38)(38)(38), "SOURCE_FILE_ID" NUMBER(38)(38)(38)(38)(38)(38)(38)(38), "EXPORTED" NUMBER(1)(1)(1), "LINE" NUMBER(38)(38)(38)(38)(38)(38)(38)(38)(38), "UPDATED_AT" DATE, "CREATED_AT" DATE) warning: Not using cache on failed catalog err: Could not retrieve catalog; skipping run *note the parenthesis are breeding* -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
