Issue #11925 has been reported by Jeff Chapin.
----------------------------------------
Bug #11925: SQL is generated improperly when tied to an Oracle DB
https://projects.puppetlabs.com/issues/11925
Author: Jeff Chapin
Status: Unreviewed
Priority: Normal
Assignee:
Category:
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.
