We made this change to fix[1], we changed all the DB scripts so that they would be consistent, but looks like now Oracle has an issue with this :(
So we will revert it back on the other scripts to CURRENT_TIMESTAMP as default(which was what existed previously) and only have a 0 as default for the MySQL DB script since there is no way of maintaining consistency across all scripts for this case anymore. [1] - https://wso2.org/jira/browse/APIMANAGER-2981 On 28 October 2014 16:23, Evanthika Amarasiri <[email protected]> wrote: > 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/>* >> > > -- Regards, Uvindra Mobile: 777733962
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
