Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Treegrid not displaying nodes from datasource

    Hello there,

    I am using SmartClient Version: v10.0p_2015-05-08/PowerEdition Deployment (built 2015-05-08) with FF26.

    I am trying to display two treegrid where user can drop nodes nodes from left to right treegrid only. The left treegrid is getting its data from a simple datasource file where i have id and one foreign key field. But the right treegrid is getting its data from a datasource which i have around 3 foreign key and after reading the TreeDataBinding, I made some changes to my code i.e. I added the setParentIdField/setIdField. But still no data is getting loaded in this treegrid.
    In the code below I am trying to tell it to use load the product names which is the parent and the child. i mean the product names dont have any parent.
    Below are my 2 datasource file and the treegrid.

    Code:
    DataSource ds = DataSource.get("distributorDS");
    DataSource dsproduct = DataSource.get("productDS");
    			
            final DistributorTreeGrid treeGrid = new DistributorTreeGrid(); 
            treeGrid.setDragDataAction(DragDataAction.MOVE);  
            treeGrid.setDataSource(ds);
            treeGrid.addDrawHandler(new DrawHandler() {  
                public void onDraw(DrawEvent event) {  
                    treeGrid.fetchData();  
                }  
            });  
            
            Tree tree = new Tree();
            //tree.setRootValue("id");
            tree.setModelType(TreeModelType.PARENT);
    		tree.setParentIdField("id");
    		tree.setIdField("id");
    		tree.setNameProperty("name");
    		
    		final CompanyTreeGrid companytreeGrid = new CompanyTreeGrid();
    		companytreeGrid.setDataProperties(tree);
    		companytreeGrid.setData(tree);
    		companytreeGrid.setDataSource(dsproduct);
    		companytreeGrid.setAutoFetchData(true);
    		/*companytreeGrid.addDrawHandler(new DrawHandler() {  
                public void onDraw(DrawEvent event) {  
                	companytreeGrid.fetchData();  
                }  
            });*/
    Code:
    <DataSource ID="distributorDS" serverType="sql" tableName="dtor">
    	<fields>
    		<field name="id" type="sequence" hidden="true" primaryKey="true" />
    		<field name="name" title="Description" type="ntext" required="true"/>
    		<field name="status" title="Status" type="boolean" />
    	</fields>
    </DataSource>
    Code:
    <DataSource ID="productDS" serverType="sql" tableName="pdu">
    
     	<fields>
    		<field name="id" type="sequence" hidden="true" primaryKey="true" />
    		<field name="name" title="Product Name" type="ntext" length="128" required="true"/>
    		<field name="code" title="Code" type="integer" required="true"/>       
    		<field name="dfid" title="Dosage Form" type="integer" foreignKey="dosformDS.id" joinType="outer" displayField = "dosageformName" required="true">
    		</field>
    		<field name="dosageformName" includeFrom="dosformDS.name" hidden="true" />
    		
    		<field name="pgr" title="Product Group" type="integer" foreignKey="productGroupDS.id" joinType="outer" displayField="productGroup" required="true"/>
    		<field name="productGroup" includeFrom="productGroupDS.name" hidden="true" />
    		
    		<field name="ro" title="Route Of Administration" type="integer" foreignKey="routeOfAdminDS.id" joinType="outer" displayField="roa" required="true"/>
    		<field name="roa" includeFrom="routeOfAdminDS.name" hidden="true" />
    		
    		<field name="pu" title="Package Unit" type="text" length="5" required="true">
    		<valueMap>
                    <value>Kg</value>
                    <value>Liter</value>
                    <value>Pcs</value>
                    <value>Other</value>
                </valueMap>
            </field>
    Attached Files

    #2
    anybody there to help me resolve this issue

    Comment


      #3
      somebody there to take a look at this and help me to identify the thing i am missing

      Comment


        #4
        somebody there to take a look at this and help me to identify the thing i am missing

        Comment


          #5
          Start by providing basic information that is always required:

          1. Server log for the request that isn't doing what you wanted

          2. Missing code such as CompanyTreeGrid / DistributorTreeGrid - or just tell with plain TreeGrid and if that also has the issue, show the log file from that

          Comment


            #6
            Hi Isomorphic,

            I am using MSSQL 2008 database and here are those server logs


            DSREQUEST Log:

            {
            dataSource:"productDS",
            operationType:"fetch",
            componentId:"isc_CompanyTreeGrid_1",
            data:{
            id:null
            },
            textMatchStyle:"exact",
            resultTree:[ResultTree ID:isc_ResultTree_3 (dataSource: productDS, created by: isc_CompanyTreeGrid_1)],
            callback:{
            caller:[ResultTree ID:isc_ResultTree_3 (dataSource: productDS, created by: isc_CompanyTreeGrid_1)],
            methodName:"loadChildrenReply"
            },
            willHandleError:true,
            showPrompt:true,
            prompt:"Finding Records that match your criteria...",
            oldValues:{
            id:null
            },
            requestId:"productDS$6274",
            internalClientContext:{
            parentNode:{
            name:"/",
            children:Array[0]
            },
            relationship:{
            childDS:[DataSource ID:productDS],
            parentDS:[DataSource ID:dosformDS],
            parentIdField:"id",
            idField:"id"
            },
            childrenReplyCallback:{
            },
            fetchCount:1
            },
            fallbackToEval:false,
            progressiveLoading:false,
            lastClientEventThreadCode:"MUP5[E0]",
            bypassCache:true
            }

            Raw Response

            {
            affectedRows:0,
            data:[
            ],
            endRow:0,
            invalidateCache:false,
            isDSResponse:true,
            operationType:"fetch",
            queueStatus:0,
            startRow:0,
            status:0,
            totalRows:0
            }


            The treegrid that is not loading data

            Code:
            public class CompanyTreeGrid extends TreeGrid
            {
            	public CompanyTreeGrid()
            	{
            		setWidth(300);
            		setHeight100();
            		setShowEdges(true);
            		setBorder("0px");
            		setBodyStyleName("normal");
            		setShowHeader(false);
            		setLeaveScrollbarGap(false);
            		setEmptyMessage("<br>Drag & drop parts here");
            		setManyItemsImage("cubes_all.png");
            		setAppImgDir("pieces/16/");
            		setCanReorderRecords(true);
            		setCanAcceptDroppedRecords(true);
            		setCanDragRecordsOut(true);
            	}
            }
            Server log:

            === 2015-06-14 08:53:38,464 [3-25] INFO RequestContext - URL: '/authApp', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding head
            er
            === 2015-06-14 08:53:38,464 [3-25] INFO Compression - /authApp: 824 -> 459 bytes
            === 2015-06-14 08:53:40,730 [3-25] INFO RequestContext - URL: '/authApp', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding head
            er
            === 2015-06-14 08:53:40,730 [3-25] INFO Compression - /authApp: 824 -> 459 bytes
            === 2015-06-14 08:53:40,740 [3-25] INFO RequestContext - URL: '/kaizenbehsa/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accep
            t-Encoding header
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Cookie:GLog=%7B%0D%20%20%20%20trackRPC%3Atrue%2C%20%0D%20%20%20%20pageGUID%3A%22467682A7-E5B0-4E92-8060-A95143B4D14D%22%2C%20
            %0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20sgwtInternal%3A1%2C%20%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20l
            eft%3A-1543%2C%20%0D%20%20%20%20top%3A-7%2C%20%0D%20%20%20%20width%3A1536%2C%20%0D%20%20%20%20height%3A809%0D%7D; JSESSIONID=157bine3rgptlzrm56gvyp167; isc_cState=ready
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Host:127.0.0.1:8888
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Content-Length:1237
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Content-Type:application/x-www-form-urlencoded; charset=UTF-8
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Accept-Language:en-US,en;q=0.5
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Pragma:no-cache
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Connection:keep-alive
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Referer:http://127.0.0.1:8888/KaizenBehsa.ht...127.0.0.1:9997
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Cache-Control:no-cache
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - Header Name:Value pair: Accept-Encoding:gzip, deflate
            === 2015-06-14 08:53:40,750 [3-25] DEBUG IDACall - session exists: 157bine3rgptlzrm56gvyp167
            === 2015-06-14 08:53:40,751 [3-25] DEBUG IDACall - remote user: null
            === 2015-06-14 08:53:40,765 [3-24] INFO RequestContext - URL: '/kaizenbehsa/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accep
            t-Encoding header
            === 2015-06-14 08:53:40,765 [3-25] DEBUG XML - Parsed XML from (in memory stream): 0ms
            === 2015-06-14 08:53:40,765 [3-24] DEBUG IDACall - Header Name:Value pair: Cookie:GLog=%7B%0D%20%20%20%20trackRPC%3Atrue%2C%20%0D%20%20%20%20pageGUID%3A%22467682A7-E5B0-4E92-8060-A95143B4D14D%22%2C%20
            %0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20sgwtInternal%3A1%2C%20%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20l
            eft%3A-1543%2C%20%0D%20%20%20%20top%3A-7%2C%20%0D%20%20%20%20width%3A1536%2C%20%0D%20%20%20%20height%3A809%0D%7D; JSESSIONID=157bine3rgptlzrm56gvyp167; isc_cState=ready
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Host:127.0.0.1:8888
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Content-Length:1207
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Content-Type:application/x-www-form-urlencoded; charset=UTF-8
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Accept-Language:en-US,en;q=0.5
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Pragma:no-cache
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Connection:keep-alive
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Referer:http://127.0.0.1:8888/KaizenBehsa.ht...127.0.0.1:9997
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Cache-Control:no-cache
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - Header Name:Value pair: Accept-Encoding:gzip, deflate
            === 2015-06-14 08:53:40,775 [3-25] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource null of type 'transaction' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-25] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource 68 of type 'Object' and assigned it to thread qtp16274653-25
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource 68 of type 'Object' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Activated DataSource 68 of type 'Object'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - session exists: 157bine3rgptlzrm56gvyp167
            === 2015-06-14 08:53:40,775 [3-24] DEBUG IDACall - remote user: null
            === 2015-06-14 08:53:40,775 [3-25] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG XML - Parsed XML from C:\dev\workspace\KaizenBehsa1\war\kaizenbehsa\sc\system\schema\List.ds.xml: 0ms
            === 2015-06-14 08:53:40,775 [3-25] DEBUG ISCKeyedObjectPool - Borrowing object for 'DataSource'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource 69 of type 'DataSource' and assigned it to thread qtp16274653-25
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource 69 of type 'DataSource' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Activated DataSource 69 of type 'DataSource'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG XML - Parsed XML from (in memory stream): 0ms
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource 70 of type 'List' and assigned it to thread qtp16274653-25
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource 70 of type 'List' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Activated DataSource 70 of type 'List'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Created DataSource null of type 'transaction' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Created DataSource 71 of type 'Object' and assigned it to thread qtp16274653-24
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Created DataSource 71 of type 'Object' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Activated DataSource 71 of type 'Object'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Created DataSource null of type 'elem' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Created DataSource 72 of type 'List' and assigned it to thread qtp16274653-24
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Created DataSource 72 of type 'List' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Activated DataSource 72 of type 'List'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG RPCManager - Processing 1 requests.
            === 2015-06-14 08:53:40,775 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Created DataSource null of type 'elem' in the pooling flow
            === 2015-06-14 08:53:40,775 [3-25] DEBUG ISCKeyedObjectPool - Borrowing object for 'distributorDS'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG PoolableDataSourceFactory - Activated DataSource 22 of type 'distributorDS'
            === 2015-06-14 08:53:40,775 [3-25] DEBUG DSRequest - Caching instance 22 of DS 'distributorDS' from DSRequest.getDataSource()
            === 2015-06-14 08:53:40,775 [3-25] DEBUG DSRequest - Caching instance 22 of DS distributorDS
            === 2015-06-14 08:53:40,775 [3-24] DEBUG RPCManager - Processing 1 requests.
            === 2015-06-14 08:53:40,775 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'productDS'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG PoolableDataSourceFactory - Activated DataSource 30 of type 'productDS'
            === 2015-06-14 08:53:40,775 [3-24] DEBUG DSRequest - Caching instance 30 of DS 'productDS' from DSRequest.getDataSource()
            === 2015-06-14 08:53:40,775 [3-24] DEBUG DSRequest - Caching instance 30 of DS productDS
            === 2015-06-14 08:53:40,775 [3-25] DEBUG RPCManager - Request #1 (DSRequest) payload: {
            criteria:{
            parentId:null
            },
            operationConfig:{
            dataSource:"distributorDS",
            repo:null,
            operationType:"fetch",
            textMatchStyle:"exact"
            },
            componentId:"isc_DistributorTreeGrid_0",
            appID:"builtinApplication",
            operation:"distributorDS_fetch",
            oldValues:{
            parentId:null
            },
            progressiveLoading:false,
            resultTreeIdField:"id",
            resultTreeParentIdField:"parentId"
            }
            === 2015-06-14 08:53:40,785 [3-24] DEBUG RPCManager - Request #1 (DSRequest) payload: {
            criteria:{
            id:null
            },
            operationConfig:{
            dataSource:"productDS",
            repo:null,
            operationType:"fetch",
            textMatchStyle:"exact"
            },
            componentId:"isc_CompanyTreeGrid_0",
            appID:"builtinApplication",
            operation:"productDS_fetch",
            oldValues:{
            id:null
            },
            progressiveLoading:false,
            resultTreeIdField:"id",
            resultTreeParentIdField:"id"
            }
            === 2015-06-14 08:53:40,785 [3-25] INFO IDACall - Performing 1 operation(s)
            === 2015-06-14 08:53:40,785 [3-24] INFO IDACall - Performing 1 operation(s)
            === 2015-06-14 08:53:40,785 [3-25] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
            === 2015-06-14 08:53:40,785 [3-25] DEBUG DeclarativeSecurity - DataSource distributorDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'dosformDS'
            === 2015-06-14 08:53:40,785 [3-24] DEBUG PoolableDataSourceFactory - Activated DataSource 13 of type 'dosformDS'
            === 2015-06-14 08:53:40,785 [3-24] DEBUG Relation - Caching instance of toDS 'dosformDS' in the DSRequest map
            === 2015-06-14 08:53:40,785 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'productGroupDS'
            === 2015-06-14 08:53:40,785 [3-24] DEBUG PoolableDataSourceFactory - Activated DataSource 16 of type 'productGroupDS'
            === 2015-06-14 08:53:40,785 [3-24] DEBUG Relation - Caching instance of toDS 'productGroupDS' in the DSRequest map
            === 2015-06-14 08:53:40,785 [3-24] DEBUG ISCKeyedObjectPool - Borrowing object for 'routeOfAdminDS'
            === 2015-06-14 08:53:40,785 [3-24] DEBUG PoolableDataSourceFactory - Activated DataSource 19 of type 'routeOfAdminDS'
            === 2015-06-14 08:53:40,785 [3-24] DEBUG Relation - Caching instance of toDS 'routeOfAdminDS' in the DSRequest map
            === 2015-06-14 08:53:40,785 [3-25] DEBUG AppBase - [builtinApplication.distributorDS_fetch] No userTypes defined, allowing anyone access to all operations for this application
            === 2015-06-14 08:53:40,785 [3-25] DEBUG AppBase - [builtinApplication.distributorDS_fetch] No public zero-argument method named '_distributorDS_fetch' found, performing generic datasource operation
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - DataSource productDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - Processing security checks for DataSource dosformDS, field id
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - DataSource dosformDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - Processing security checks for DataSource dosformDS, field name
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - DataSource dosformDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - Processing security checks for DataSource productGroupDS, field id
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - DataSource productGroupDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - Processing security checks for DataSource productGroupDS, field name
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - DataSource productGroupDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - Processing security checks for DataSource routeOfAdminDS, field id
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - DataSource routeOfAdminDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - Processing security checks for DataSource routeOfAdminDS, field name
            === 2015-06-14 08:53:40,785 [3-24] DEBUG DeclarativeSecurity - DataSource routeOfAdminDS is not in the pre-checked list, processing...
            === 2015-06-14 08:53:40,785 [3-25] INFO SQLDataSource - [builtinApplication.distributorDS_fetch] Performing fetch operation with
            criteria: {parentId:null} values: {parentId:null}
            === 2015-06-14 08:53:40,785 [3-25] INFO SQLDataSource - [builtinApplication.distributorDS_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
            === 2015-06-14 08:53:40,785 [3-24] DEBUG AppBase - [builtinApplication.productDS_fetch] No userTypes defined, allowing anyone access to all operations for this application
            === 2015-06-14 08:53:40,785 [3-25] INFO SQLDataSource - [builtinApplication.distributorDS_fetch] 22: Executing SQL query on 'SQLServer': SELECT dtor.id, dtor.name, dtor.status FROM dtor WHERE ('1'='1
            ')
            === 2015-06-14 08:53:40,785 [3-24] DEBUG AppBase - [builtinApplication.productDS_fetch] No public zero-argument method named '_productDS_fetch' found, performing generic datasource operation
            === 2015-06-14 08:53:40,785 [3-25] DEBUG SQLConnectionManager - [builtinApplication.distributorDS_fetch] Borrowed connection '23042732'
            === 2015-06-14 08:53:40,785 [3-25] DEBUG SQLDriver - [builtinApplication.distributorDS_fetch] About to execute SQL query in 'SQLServer' using connection '23042732'
            === 2015-06-14 08:53:40,785 [3-25] INFO SQLDriver - [builtinApplication.distributorDS_fetch] Executing SQL query on 'SQLServer': SELECT dtor.id, dtor.name, dtor.status FROM dtor WHERE ('1'='1')
            === 2015-06-14 08:53:40,785 [3-24] INFO SQLDataSource - [builtinApplication.productDS_fetch] Performing fetch operation with
            criteria: {id:null} values: {id:null}
            === 2015-06-14 08:53:40,785 [3-24] INFO SQLDataSource - [builtinApplication.productDS_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause$defaultAnsiJoinClause WHERE $defaultWh
            ereClause
            === 2015-06-14 08:53:40,795 [3-24] INFO SQLDataSource - [builtinApplication.productDS_fetch] 30: Executing SQL query on 'SQLServer': SELECT pdu.id, pdu.name, pdu.code, pdu.fptype, pdu.dfid, pdu.pgr,
            pdu.ro, pdu.pu, pdu.supck, pdu.mupck, pdu.nper, pdu.neng, pdu.gcde, pdu.dcde, pdu.oirc, pdu.nirc, pdu.gtin, pdu.slife, pdu.status, dfor.name AS dosageformName, pdgrp.name AS productGroup, roa.name AS
            roa FROM pdu LEFT OUTER JOIN dfor ON pdu.dfid = dfor.id LEFT OUTER JOIN pdgrp ON pdu.pgr = pdgrp.id LEFT OUTER JOIN roa ON pdu.ro = roa.id WHERE (pdu.id IS NULL)
            === 2015-06-14 08:53:40,795 [3-24] DEBUG PoolableSQLConnectionFactory - [builtinApplication.productDS_fetch] DriverManager fetching connection for SQLServer via jdbc url jdbc:jtds:sqlserver://localhos
            t:1433;DatabaseName=kaizenbehsa;useUnicode=true;characterEncoding=UTF-8;sendStringAsUnicode=true;User=test;Password=secret
            === 2015-06-14 08:53:40,795 [3-24] DEBUG PoolableSQLConnectionFactory - [builtinApplication.productDS_fetch] Passing JDBC URL only to getConnection
            === 2015-06-14 08:53:40,795 [3-25] INFO DSResponse - [builtinApplication.distributorDS_fetch] DSResponse: List with 3 items
            === 2015-06-14 08:53:40,795 [3-25] DEBUG DSRequest - About to free up resources for request of type fetch on DataSource distributorDS
            === 2015-06-14 08:53:40,795 [3-25] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
            === 2015-06-14 08:53:40,795 [3-25] DEBUG RPCManager - non-DMI response, dropExtraFields: false
            === 2015-06-14 08:53:40,795 [3-24] DEBUG PoolableSQLConnectionFactory - [builtinApplication.productDS_fetch] makeObject() created a pooled Connection '1672403'
            === 2015-06-14 08:53:40,795 [3-24] DEBUG SQLConnectionManager - [builtinApplication.productDS_fetch] Borrowed connection '1672403'
            === 2015-06-14 08:53:40,795 [3-24] DEBUG SQLDriver - [builtinApplication.productDS_fetch] About to execute SQL query in 'SQLServer' using connection '1672403'
            === 2015-06-14 08:53:40,795 [3-24] INFO SQLDriver - [builtinApplication.productDS_fetch] Executing SQL query on 'SQLServer': SELECT pdu.id, pdu.name, pdu.code, pdu.fptype, pdu.dfid, pdu.pgr, pdu.ro,
            pdu.pu, pdu.supck, pdu.mupck, pdu.nper, pdu.neng, pdu.gcde, pdu.dcde, pdu.oirc, pdu.nirc, pdu.gtin, pdu.slife, pdu.status, dfor.name AS dosageformName, pdgrp.name AS productGroup, roa.name AS roa FROM
            pdu LEFT OUTER JOIN dfor ON pdu.dfid = dfor.id LEFT OUTER JOIN pdgrp ON pdu.pgr = pdgrp.id LEFT OUTER JOIN roa ON pdu.ro = roa.id WHERE (pdu.id IS NULL)
            === 2015-06-14 08:53:40,795 [3-25] DEBUG SQLDriver - Freeing SQLDriver dbConnection 23042732
            === 2015-06-14 08:53:40,795 [3-25] DEBUG SQLConnectionManager - About to close connection with hashcode "23042732"
            === 2015-06-14 08:53:40,795 [3-25] DEBUG PoolableDataSourceFactory - Cleared and passivated DataSource 22 of type 'distributorDS'
            === 2015-06-14 08:53:40,795 [3-24] INFO DSResponse - [builtinApplication.productDS_fetch] DSResponse: List with 0 items
            === 2015-06-14 08:53:40,795 [3-25] INFO Compression - /kaizenbehsa/sc/IDACall: 277 -> 196 bytes
            === 2015-06-14 08:53:40,795 [3-24] DEBUG DSRequest - About to free up resources for request of type fetch on DataSource productDS
            === 2015-06-14 08:53:40,795 [3-24] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
            === 2015-06-14 08:53:40,795 [3-24] DEBUG RPCManager - non-DMI response, dropExtraFields: false
            === 2015-06-14 08:53:40,795 [3-24] DEBUG SQLDriver - Freeing SQLDriver dbConnection 1672403
            === 2015-06-14 08:53:40,795 [3-24] DEBUG SQLConnectionManager - About to close connection with hashcode "1672403"
            === 2015-06-14 08:53:40,795 [3-24] DEBUG PoolableDataSourceFactory - Cleared and passivated DataSource 19 of type 'routeOfAdminDS'
            === 2015-06-14 08:53:40,795 [3-24] DEBUG PoolableDataSourceFactory - Cleared and passivated DataSource 16 of type 'productGroupDS'
            === 2015-06-14 08:53:40,795 [3-24] DEBUG PoolableDataSourceFactory - Cleared and passivated DataSource 13 of type 'dosformDS'
            === 2015-06-14 08:53:40,795 [3-24] DEBUG PoolableDataSourceFactory - Cleared and passivated DataSource 30 of type 'productDS'
            === 2015-06-14 08:53:40,795 [3-24] INFO Compression - /kaizenbehsa/sc/IDACall: 188 -> 152 bytes
            Last edited by zaj; 13 Jun 2015, 20:25. Reason: Forgot to show the server log

            Comment


              #7
              This looks to be the same issue as your other thread - you have not set up a rootValue, and obviously no records in your database match the default rootValue of null. Solution is the same as that explained in the other thread.

              Comment

              Working...
              X