Announcement

**RickBollinger** · 13 Aug 2014, 07:36

Solved my problem.

I thought the solution was to delete autoDeriveSchema="true" in the ds.xml. Removing autoDeriveSchema="true" lets me add records.

I tried removing the primaryKey="true" for both fields without effect.

Looking through the trace I tried to figure out why SQLValuesClause would be trying fill (incorrectly null) values for TaskID and TeamMemberID with '__default'.

I tried setting primaryKey="false". I am surprised that autoDeriveSchema overrides these specific indications or fails to complain about the inconsistency.

But, now find that without primaryKey="true" I get an error that there is are no primary keys. And, when I add primaryKey="true" to the fields, I get an error the values are missing. But, they are not. They are clearly in the values supplied.

Thanks,

Rick

**RickBollinger** · 13 Aug 2014, 11:58

I think I solved it again.

The solution may be Colonel Mustard with the candlestick in the library.

No, actually it may be primaryKey="true" without autoDeriveSchema="true".

But, weirdly, a CVS diff shows primaryKey="true" with autoDeriveSchema="true" was my initial configuration. All I can think of was that I never tried the correct combination until just now.

I use this in another spot. So, I will see if the solution holds twice.

Rick

**RickBollinger** · 14 Aug 2014, 11:46

operation missing the following required unique and/or primary fields

I feel like I am playing 'whack-a-mole'. I fix one thing and another problem pops up.

The latest error is

Criteria received from the client for update operation is missing the following required unique and/or primary fields: [TaskID, TeamMemberID]. Either provide all primary key fields or set allowMultiUpdate on the OperationBinding

So, I am trying to work out why, given the following log segment. It shows values TeamMemberID:102, and TaskID:106.

=== 2014-08-14 18:55:03,956 [sor2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
},
values:{
StatusChangeOption:true,
EmailAlertOption:true,
Enabled:true,
DueReminderDate:new Date(1407888000000),
CommunityID:101,
TeamMemberID:102,
TaskID:106,
IssueOwnerAlerts:true,
TaskOwnerAlerts:true,
OrganizationName:"Universal Motors",
DueReminderTime:new Date(28800000),
DueReminderOption:true,
SmsAlertOption:false,
AnyChangeOption:false,
Created:new Date(1407944720000),
TeamMemberEmail:"vicki@menloparkassociates.com",
Modified:new Date(1343044800000),
TeamMemberName:"Vicki Spencer",
Internal:false,
TeamMemberSMS:"7346457170",
ProjectID:102,
_selection_30:true
},
operationConfig:{
dataSource:"TaskSubscriber",
operationType:"update"
},
componentId:"TaskSubscriberForm",
appID:"builtinApplication",
operation:"TaskSubscriber_update",
oldValues:{
StatusChangeOption:true,
EmailAlertOption:true,
Enabled:true,
DueReminderDate:new Date(1407888000000),
CommunityID:101,
TeamMemberID:102,
TaskID:106,
IssueOwnerAlerts:true,
TaskOwnerAlerts:true,
OrganizationName:"Universal Motors",
DueReminderTime:new Date(28800000),
DueReminderOption:true,
SmsAlertOption:false,
AnyChangeOption:true,
Created:new Date(1407944720000),
TeamMemberEmail:"vicki@menloparkassociates.com",
Modified:new Date(1343044800000),
TeamMemberName:"Vicki Spencer",
Internal:false,
TeamMemberSMS:"7346457170",
ProjectID:102,
_selection_30:true
}
}
=== 2014-08-14 18:55:03,956 [sor2] INFO IDACall - Performing 1 operation(s)
=== 2014-08-14 18:55:03,956 [sor2] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2014-08-14 18:55:03,956 [sor2] DEBUG DeclarativeSecurity - DataSource TaskSubscriber is not in the pre-checked list, processing...
=== 2014-08-14 18:55:03,956 [sor2] DEBUG AppBase - [builtinApplication.TaskSubscriber_update] No userTypes defined, allowing anyone access to all operations for this application
=== 2014-08-14 18:55:03,956 [sor2] DEBUG AppBase - [builtinApplication.TaskSubscriber_update] No public zero-argument method named '_TaskSubscriber_update' found, performing generic datasource operation
=== 2014-08-14 18:55:03,971 [sor2] WARN RequestContext - dsRequest.execute() failed:
com.isomorphic.base.UpdateWithoutPKException: Criteria received from the client for update operation is missing the following required unique and/or primary fields: [TaskID, TeamMemberID]. Either provide all primary key fields or set allowMultiUpdate on the OperationBinding
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:705)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2042)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:216)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:173)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:138)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:74)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.isomorphic.js.JSSyntaxScannerFilter.doFilter(JSSyntaxScannerFilter.java:242)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:722)

I have truncated the isc.DataSource.create to just the ID. So, I think I am using the ds.xml definition for it.

Code:

<DataSource ID="TaskSubscriber" serverType="sql" dataSourceVersion="1" dbName="PlanetProjectDB" schema="PUBLIC" tableName="TaskSubscriber" >
    <fields>
        <field name="TaskID" type="integer" required="true" primaryKey="true"/>
        <field name="ProjectID" required="true" type="integer"/>   
        <field name="CommunityID" required="true" type="integer"/>
        <field name="OrganizationName" type="text" required="false" title="Organization" detail="false" canEdit="false">
		     <tableName>Organization</tableName>
        </field>
        <field name="Internal" type="boolean" required="false" title="Internal" canEdit="false" sqlStorageStrategy="integer">
		     <tableName>Organization</tableName>
        </field>        
        <field name="TeamMemberID" type="integer" required="true" primaryKey="true"/>
        <field name="TeamMemberName" type="text" title="Subscriber" detail="false" canEdit="false">
            <tableName>TeamMember</tableName>
        </field>
        <field name="Enabled" type="boolean" required="false" title="Enabled" canEdit="false" sqlStorageStrategy="integer">
            <tableName>TeamMember</tableName>
        </field>        
        <field name="TeamMemberEmail" type="text" length="64" title="Email" canEdit="false">
            <tableName>TeamMember</tableName>
        </field>
        <field name="TeamMemberSMS" type="text" length="64" title="SMS" canEdit="false">
            <tableName>TeamMember</tableName>
        </field>
		<field name="EmailAlertOption" type="boolean" required="false" title="Email Alerts" canEdit="false" sqlStorageStrategy="integer">
            <tableName>TeamMember</tableName>
        </field>
		<field name="SmsAlertOption" type="boolean" required="false" title="SMS Alerts" canEdit="false" sqlStorageStrategy="integer">
            <tableName>TeamMember</tableName>
        </field>
		<field name="IssueOwnerAlerts" type="boolean" required="false" title="Auto Issue Alerts" canEdit="false" sqlStorageStrategy="integer">
            <tableName>TeamMember</tableName>
        </field>
		<field name="TaskOwnerAlerts" type="boolean" required="false" title="Auto Task Alerts" canEdit="false" sqlStorageStrategy="integer">
            <tableName>TeamMember</tableName>
        </field>         
        <field name="AnyChangeOption" type="boolean" required="true" title="Any Change Option" canEdit="true" sqlStorageStrategy="integer"/>
        <field name="StatusChangeOption" type="boolean" required="true" title="Status Change Option" canEdit="true" sqlStorageStrategy="integer"/>
        <field name="DueReminderOption" type="boolean" required="true" title="Due Reminder Option" canEdit="true" sqlStorageStrategy="integer"/>
        <field name="DueReminderDate" type="date"/>
        <field name="DueReminderTime" type="time"/>
        <field name="Created" type="datetime" detail="true"/>
        <field name="Modified" type="datetime" detail="true"/>
    </fields>
    <operationBindings>
        <OperationBinding>
            <operationType>fetch</operationType>
            <tableClause>TaskSubscriber LEFT JOIN TeamMember ON TaskSubscriber.TeamMemberID = TeamMember.TeamMemberID LEFT JOIN Organization ON TeamMember.OrganizationID = Organization.OrganizationID </tableClause>
            <whereClause>($defaultWhereClause)</whereClause>
        </OperationBinding>
    </operationBindings>     
    <title>TaskSubscriber</title>
    <pluralTitle>TaskSubscribers</pluralTitle>
    <generatedBy>v8.2p_2013-01-14/EVAL Deployment 2013-01-14</generatedBy>
</DataSource>

It is missing autoDeriveSchema="true". So, the default 'null' means false, right. And, I identify the missing keys as primaryKey="true". Therefore the system must be looking for them among the values. I assume.

Actually, I don't assume. As can be seen, I have no explicit update operationBinding. My next test will be making an explicit one that uses those values. I just need to figure out how to phrase it.

Ever onward.

Rick

**RickBollinger** · 14 Aug 2014, 13:32

another tack

Well, the customSQL did not work. I don't know how to get my key values into the criteria for the update. If I could do that, I suspect a vanilla update binding work work as well.

Code:

       <OperationBinding>
            <operationType>update</operationType>
            <customSQL>UPDATE TaskSubscriber SET $defaultValuesClause WHERE TaskID = $criteria.TaskID AND TeamMemberID = $criteria.TeamMemberID</customSQL>
        </OperationBinding>

Rick

**RickBollinger** · 15 Aug 2014, 10:31

Situation semi-solved.

The problem was deeper than I thought: DataSource.load() does not apply the addGlobalId="true" parameter like DataSource.create() does.

And, simultaneously, DataSource.create() does not bring along the primaryKey="true" field parameters that DataSource.load() does, supposedly.

My fix is to DataSource.create() with only the ID and fields for the primary keys. Everything else inherits.

I really wanted to do a mass DataSource.load() at the beginning. But, none of the datasources was global and my jsp failed quickly.

Hope this helps somebody in the same boat.

Maybe there is some other fix. I would certainly like to know what it is.

Rick

Announcement

primary key field doesn't have a default value

Comment

Comment

Comment

Comment

Comment