Hi Uvindra, The Oracle DB script of the latest API-M pack (27th Oct) fails due to the following of the AM_WORKFLOWS table.
*WF_CREATED_TIME TIMESTAMP DEFAULT 0,* Since testing on the setup was blocked from this issue, we updated the script as below. *WF_CREATED_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP* Jira reported at [1] [1] - https://wso2.org/jira/browse/APIMANAGER-3021 Regards, Evanthika On Wed, Oct 22, 2014 at 3:22 PM, Yasassri Ratnayake <[email protected]> wrote: > Thanks, We will be using the provided scripts for time being. > > On Wed, Oct 22, 2014 at 2:52 PM, Uvindra Dias Jayasinha <[email protected]> > wrote: > >> Ticket has been resolved and the updated scripts can be obtained from >> here till a new pack is issued, >> >> >> https://svn.wso2.org/repos/wso2/carbon/platform/branches/turing/products/apimgt/1.8.0/modules/distribution/resources/sql/ >> >> You can use these scripts instead of the ones in the 20 October pack to >> create databases for your testing >> >> On 22 October 2014 10:02, Uvindra Dias Jayasinha <[email protected]> >> wrote: >> >>> Yes you can use the scripts from the previous pack to continue but >>> refrain from testing any *work flow* related functionality until we >>> resolve this for the moment. >>> >>> We will change this so that it is backward compatible. >>> >>> On 22 October 2014 09:59, Yasassri Ratnayake <[email protected]> wrote: >>> >>>> Hi Uvindra, >>>> >>>> I'm using *mysql 5.5.40*. Till you fix this issue is it OK if we use >>>> the scripts from the 6th October pack since this issue is blocking us. >>>> >>>> With regards, >>>> >>>> On Wed, Oct 22, 2014 at 9:50 AM, Uvindra Dias Jayasinha < >>>> [email protected]> wrote: >>>> >>>>> The change to the script was introduced via the resolution of this >>>>> ticket, >>>>> >>>>> https://wso2.org/jira/browse/APIMANAGER-2536 >>>>> >>>>> This issue is MySQL version dependent and does not occur on version >>>>> 5.6.5 and above. Most probably this was tested on a newer version of MySQL >>>>> during development and therefore did not cause any issues. >>>>> >>>>> On 22 October 2014 09:41, Uvindra Dias Jayasinha <[email protected]> >>>>> wrote: >>>>> >>>>>> I am looking into this, the script has been changed recently >>>>>> >>>>>> On 22 October 2014 07:53, Yasassri Ratnayake <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi All, >>>>>>> >>>>>>> There seems to be an Syntax error in the mysql DB scripts(apim >>>>>>> scripts), and due to this some of the tables do not get created. I have >>>>>>> reported this at [1]. Since this is a blocking issue pls provide a fix >>>>>>> ASAP. >>>>>>> >>>>>>> When the server is started with -Dsetup parameter the server doesn't >>>>>>> even throw an error indicating that the DB scripts haven't executed >>>>>>> properly. Isn't this another concern? >>>>>>> >>>>>>> [1] - https://wso2.org/jira/browse/APIMANAGER-2981 >>>>>>> -- >>>>>>> Yasassri Ratnayake >>>>>>> Software Engineer - QA >>>>>>> WSO2 Inc ; http://wso2.com >>>>>>> lean.enterprise.middleware >>>>>>> *Mobile : +94715933168 <%2B94715933168>* >>>>>>> *Blog : http://yasassriratnayake.blogspot.com/ >>>>>>> <http://yasassriratnayake.blogspot.com/>* >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> Uvindra >>>>>> >>>>>> Mobile: 777733962 >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards, >>>>> Uvindra >>>>> >>>>> Mobile: 777733962 >>>>> >>>> >>>> >>>> >>>> -- >>>> Yasassri Ratnayake >>>> Software Engineer - QA >>>> WSO2 Inc ; http://wso2.com >>>> lean.enterprise.middleware >>>> *Mobile : +94715933168 <%2B94715933168>* >>>> *Blog : http://yasassriratnayake.blogspot.com/ >>>> <http://yasassriratnayake.blogspot.com/>* >>>> >>> >>> >>> >>> -- >>> Regards, >>> Uvindra >>> >>> Mobile: 777733962 >>> >> >> >> >> -- >> Regards, >> Uvindra >> >> Mobile: 777733962 >> > > > > -- > Yasassri Ratnayake > Software Engineer - QA > WSO2 Inc ; http://wso2.com > lean.enterprise.middleware > *Mobile : +94715933168 <%2B94715933168>* > *Blog : http://yasassriratnayake.blogspot.com/ > <http://yasassriratnayake.blogspot.com/>* >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
