View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002886 | SAS.Планета | Баг / Bug | public | 04-11-2015 08:55 | 18-11-2015 09:58 |
| Reporter | sheavy | Assigned To | zed | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | Windows | OS | 7 | OS Version | Professional |
| Product Version | 151111 | ||||
| Target Version | 160606 | Fixed in Version | 160606 | ||
| Summary | 0002886: Ошибка при импорте sml-файла в MS SQL | ||||
| Description | при импорте возникает ошибка MarkSystemORM: Update operarion is failed! да, именно так - operarion, а не operation. | ||||
| Steps To Reproduce | Подключение к MS SQL через ODBC | ||||
| Additional Information | в таблице Mark поле mGeoWKB остается равным NULL Возможно проблема в длине поля lonlatarr в sml-файле. Но в mysql импорт проходит без проблем. Возможно, ограничения связаны с типом данных varbinary(max) поля mGeoWKB в MS SQL. | ||||
| Tags | No tags attached. | ||||
| Attached Files | problem_marks2.sml (17,711 bytes)
<?xml version="1.0" standalone="yes"?> <DATAPACKET Version="2.0"> <METADATA> <FIELDS> <FIELD attrname="id" fieldtype="i4" readonly="true" SUBTYPE="Autoinc"/> <FIELD attrname="name" fieldtype="string" WIDTH="255"/> <FIELD attrname="descr" fieldtype="bin.hex" SUBTYPE="Text"/> <FIELD attrname="scale1" fieldtype="i4"/> <FIELD attrname="scale2" fieldtype="i4"/> <FIELD attrname="lonlatarr" fieldtype="bin.hex" SUBTYPE="Binary"/> <FIELD attrname="lonL" fieldtype="r8"/> <FIELD attrname="latT" fieldtype="r8"/> <FIELD attrname="LonR" fieldtype="r8"/> <FIELD attrname="LatB" fieldtype="r8"/> <FIELD attrname="color1" fieldtype="i4"/> <FIELD attrname="color2" fieldtype="i4"/> <FIELD attrname="visible" fieldtype="boolean"/> <FIELD attrname="picname" fieldtype="string" WIDTH="20"/> <FIELD attrname="categoryid" fieldtype="i4"/> </FIELDS> <PARAMS AUTOINCVALUE="2" DEFAULT_ORDER=""/> </METADATA> <ROWDATA> <ROW id="1" name="test" descr="" scale1="2" scale2="0" lonlatarr="AKj2/zM6c+oDQAD4SGWk21H1BEAAAAAAAODwNgy67+oDQAB4ktVOrBz1BEAAAAAAAAAAAAD8f+wDQACQuKBl1OP0BEAAAAAAAAAAAADgfewDQACQIZ1oGrr0BEAAAAAAAAAAAADk4O4DQABYIxqvuq70BEAAAAAAAPCfpwGD5PADQAD46uOh7470BEAAAAAAAJjYfFwbqoMEQACYgJiEC7nyBEAAAAAAADjDDfj8sIMEQADYc9L7xtfyBEAAAAAAAMhuZvSjQYQEQACAvB5Mit/yBEAAAAAAAKB/gwiMoIQEQADAd9UuhvPyBEAAAAAAAFgx3nhGsIQEQABwM7UtPCXzBEAAAAAAALjtmv6xD4UEQABoEAJcTS7zBEAAAAAAALjtmv6I/IQEQABYIhSpijrzBEAAAAAAAKAxT+EcuIQEQAAI2O8sqUjzBEAAAAAAAGARuDmBCoUEQADoF311onfzBEAAAAAAAGii3COMS4UEQABoMIORgpXzBEAAAAAAAOBuMDnQ3YUEQACInVLhlrjzBEAAAAAAAFBlHmYyr4UEQADo8SbFPu/zBEAAAAAAAEg8XE4fLoYEQABgxD4hcwX0BEAAAAAAABB5Vlmy5IYEQAD4wIRaK8DzBEAAAAAAADDRF00BP4cEQACQue3mPMrzBEAAAAAAABj/mB0mtIcEQADAOq4/+Vj0BEAAAAAAAADmvnOy9IYEQADYZMuZ3IX0BEAAAAAAANjICKWUo4YEQADIwDfX02L0BEAAAAAAAFBFar+dpYYEQAB49C97D0v0BEAAAAAAABAb5Z7rWIYEQAAg5jMTjEL0BEAAAAAAALBlQFk6yoUEQAA4IUzQ3J30BEAAAAAAAGBQBzfmS4YEQABgL6fWut/0BEAAAAAAAODU4PAirYYEQABIsBoFb+30BEAAAAAAACD8Oa9CA4kEQAD4L87aJfP0BEAAAAAAAFBfJgisgIkEQADIm6Z9Zsf0BEAAAAAAAMAcqUrdrYkEQACo9TlSZ5L0BEAAAAAAAPCkTrjr4YkEQADoOZMAVKf0BEAAAAAAADj7TS/G8okEQADgpxFo4Mz0BEAAAAAAAPiRqD8J6okEQACAbX7HmfD0BEAAAAAAAKDixnCZEosEQABAbSJTS0D1BEAAAAAAAACnsFJBxYsEQACAMhtkkhH1BEAAAAAAALDXEhzcOYwEQAAw96mQyA31BEAAAAAAAOBp1AVRVYwEQAAo0oKV3fP0BEAAAAAAADC1hMdRh40EQABYNcPLuA71BEAAAAAAAAiXlJumZo0EQADwrkZDh7b0BEAAAAAAAAiXlJuooI0EQACA2DkaIrP0BEAAAAAAAAiXlJvNmY0EQAAg/jk1P5H0BEAAAAAAADAIUmDBXY4EQABAgVWHf8H0BEAAAAAAAMCCEzBTIo8EQAAwFKcd4Hv0BEAAAAAAABC67oTtI44EQACgeIJKk6vzBEAAAAAAAJDd5pT1GI4EQADIkMrM06fzBEAAAAAAAJDd5hRKF44EQAB4pqQ/mJLzBEAAAAAAALBW0nCz2Y0EQAD4QG1a8W3zBEAAAAAAALie/H6xWY0EQACIzpEYwW7zBEAAAAAAAOjxtPzAJY0EQACYLsTqj2DzBEAAAAAAAFCmNgvPDY0EQADwzY0AFmLzBEAAAAAAAFCmNos494wEQAAQlV43jFbzBEAAAAAAABBN2ekH5YwEQAC4xMpo5DPzBEAAAAAAAMgsexLYzIwEQAAImPkOfjLzBEAAAAAAAKjzqPi/s4wEQAAYi4o4nRTzBEAAAAAAAMh+FkuRvIwEQADYgxCQLwHzBEAAAAAAAACrI0c684wEQABos7ES8+zyBEAAAAAAALicCIc+9IwEQADwRfKfQtryBEAAAAAAACCdgZGX1YwEQABoJAnCFdDyBEAAAAAAAPDuJjOd1YwEQAA4XcHZ68ryBEAAAAAAAPjrTneeCI0EQADYxwp+G8LyBEAAAAAAAHDJcad0II0EQACQsn4zMY3yBEAAAAAAAKDt7HwVGY0EQACY3mPTPnDyBEAAAAAAAOhqpAUKMY0EQADw+EAElGfyBEAAAAAAAAAYRWh/HI0EQAB4McbmlG7xBEAAAAAAAGj1llMF+4wEQABgBEPVpCjxBEAAAAAAAFBIlfwyyYwEQADwSDbi8RfxBEAAAAAAAHj9SXzutIwEQAAIBhA+lIjwBEAAAAAAAIgK1c3Fz4wEQACACKpGr3bwBEAAAAAAACB7TZ532owEQACgz0pqsUfwBEAAAAAAALgV8ZRzkIwEQAAYC/1I0S3wBEAAAAAAAHDS+8bXjowEQABQhA1PrxTwBEAAAAAAAODM30DPH40EQADokC6K5xHwBEAAAAAAADg656c4To0EQAC4ErpL4uzvBEAAAAAAADje5Lfo5I0EQABY3eo56e3vBEAAAAAAAKA8LNSa5o0EQADIw3sOLLfvBEAAAAAAAKDMP/omrY0EQADY00fgD6/vBEAAAAAAADjhJTj1gY0EQACYg9kEGHbvBEAAAAAAAMhYrhOlnY0EQACQlzBS2ezuBEAAAAAAAOhB4J25340EQADQeQuXftHuBEAAAAAAABD21AB1QY4EQAC46p2Jms/uBEAAAAAAACBpN/qYf44EQACwz2OUZ97uBEAAAAAAAFi1r9aV/I0EQACIgBKYkiruBEAAAAAAAFi1r9ZXpI0EQABQqBdG9yjuBEAAAAAAAND5yMP9po0EQACY4O+lKxTuBEAAAAAAAAjw3eaN040EQAAIvw0xXhPuBEAAAAAAAMh1jCsu3o0EQACQf2YQHxjuBEAAAAAAAIAmMytLA44EQAAo1QifqATuBEAAAAAAAEgB3UvI3Y0EQACYT91qNgbuBEAAAAAAAJgLvEispo0EQACYoxclpxDuBEAAAAAAACjXcub9VI0EQABg3iGiRRnuBEAAAAAAAIhvwG/SPo0EQAB40NLL6xbuBEAAAAAAAGi3zjnvPI0EQACIC2z8ivrtBEAAAAAAAOgTsNqAo40EQAAw08T7IMvtBEAAAAAAAOgTsFoDko0EQADgSRGgq7ntBEAAAAAAAHCjyqKev40EQAAoNiRTUrPtBEAAAAAAADiLuC7IsI0EQAD4z2LZYZrtBEAAAAAAADiLuB5aL40EQADYBPXUgmftBEAAAAAAAFgO9FDbRo0EQADAXihgOzjtBEAAAAAAAGBgKpkw0YwEQADQ8WBgIivtBEAAAAAAAMgGyA77sYwEQADAXBCRQAjtBEAAAAAAACCEDxZMaIwEQAAQ/pSE1/rsBEAAAAAAAMh2lkNOG4wEQACQ3tNd0wHtBEAAAAAAAMh2lkPBxosEQABAk4N91+LsBEAAAAAAANDHtaFirIsEQACgk943vvbsBEAAAAAAAMBSliGOZYsEQADgLvt1p8vsBEAAAAAAAHDNfJn1ZYsEQACQfCMQXrLsBEAAAAAAAICo+wCkVosEQACoSumZXoLsBEAAAAAAAMAFMgvaMIsEQADgjRj0537sBEAAAAAAAOB9qRhiIYsEQAAAYjgPlWfsBEAAAAAAAKB8prSt5ooEQADA4Ud+oFLsBEAAAAAAAMCLWJKf5ooEQADQWME8V2TsBEAAAAAAAHD7LHuyu4kEQAB4JcH9OprsBEAAAAAAAHBnG1l7YIkEQAAo38Wg7dDsBEAAAAAAAFD4u00BUIkEQABwsq4CfLzsBEAAAAAAANDAlGOdIokEQABIssQDhrbsBEAAAAAAAAgfwDUx3IgEQADAdCc6SszsBEAAAAAAAGgclbbMfogEQAAQbYDIbrHsBEAAAAAAAECTz+dHZ4gEQACoTTNEK43sBEAAAAAAAJjELIvzyYcEQAAAgQk6y8DsBEAAAAAAAMDt5C5ftIcEQAD45RbXofPsBEAAAAAAAMDt5O5Go4cEQACAotP0UdTsBEAAAAAAALgMhtTHM4cEQAC4bq6n0c3sBEAAAAAAAKg73DPtKocEQADg47yEed3sBEAAAAAAAKg73POfP4cEQACwl0A5RuzsBEAAAAAAAGi36YYrF4cEQACI+SyVOiHtBEAAAAAAAIAIJc5Vw4YEQACwbmAvEz7tBEAAAAAAAEChAQANpIYEQAB4dOraFDztBEAAAAAAAJji7w1BroYEQABIJOolq0jtBEAAAAAAAFimEKmSqIYEQAAA5TEgsU3tBEAAAAAAAFimEKlUfYYEQACAeq7Ogk/tBEAAAAAAAMDcMUaghIYEQADYQ052HYjtBEAAAAAAADhqZRE6JoYEQADovSG7YYztBEAAAAAAAACSOD/cGIYEQABoVgWWO4PtBEAAAAAAAFAFimR3ZIUEQAAYasd4yIrtBEAAAAAAADDVEnecX4UEQABgnw08tULtBEAAAAAAAHCcGIXPC4UEQAAwl/j8CkntBEAAAAAAANCYkhp2C4UEQABYwyvHZVntBEAAAAAAADDTp8RipIQEQAAIlaR2+IjtBEAAAAAAAMC1fG2uQ4QEQAAYqwwTy4TtBEAAAAAAADDTp8TyQYQEQACgcj//VK/tBEAAAAAAAIB2riYDA4QEQADwaG792rTtBEAAAAAAAIAE9vEk3oMEQAAw3vgdk67tBEAAAAAAAKjq9c5A4oMEQAAYWMpebpHtBEAAAAAAANhhRqplr4MEQABAf+kjKWXtBEAAAAAAAEiRHL3MYoMEQACoOoxvI2XtBEAAAAAAAKhwBKkU64IEQAAY0egOYgftBEAAAAAAAMDpC2BmEYMEQACYbD3VN+nsBEAAAAAAAIiD2NNgF4MEQADIcKrSbtbsBEAAAAAAALjl4Mwb9oIEQACQ6plKDsjsBEAAAAAAALjl4EzADYMEQAB4/BaaNcDsBEAAAAAAALAvJNAqn4IEQAA4G9GuAHzsBEAAAAAAAKDZVov8yoEEQAAobB3GiG7sBEAAAAAAAIALjQBBj4EEQACwSwSvApLsBEAAAAAAAJCMgrbHr4EEQAAotuc45KPsBEAAAAAAABhs8OtHJIEEQABAkt7jK9DsBEAAAAAAAHg3DP8XNYEEQAAwyqKv1t7sBEAAAAAAABAYnuSZRYEEQACYIIlU6PrsBEAAAAAAALi6u1iPRoEEQABwK6NcTA/tBEAAAAAAAPDL2j8SHoEEQADACpCkSCftBEAAAAAAAPDL2j9m94AEQABIg9nM6SftBEAAAAAAAPDL2p+l34AEQABQz9tsdBrtBEAAAAAAAPDL2p8c0oAEQACItlBSfyftBEAAAAAAAPDL2p+u1oAEQACQHInoLDTtBEAAAAAAAPDL2p/t8YAEQACgbe9KlEDtBEAAAAAAAIhEoWXdv4AEQAAwYAK37kbtBEAAAAAAAKDp4sMidoAEQABYxx6NnnztBEAAAAAAAKDp4oNueYAEQABw8e1T4IftBEAAAAAAAGjGy3m96/8DQAAwsgEmd6XtBEAAAAAAAGjGy3nc6v8DQACYl4ndQrDtBEAAAAAAAGjGy3nE1f8DQAAItr/3h7ztBEAAAAAAADg55hoAI/4DQADgwI9zP0ftBEAAAAAAAHBM544NpPwDQAC43+RgP3vtBEAAAAAAAEjka5hbVvwDQAAoK/8FxCztBEAAAAAAANDFZmB/ZvwDQAAQc1iEbgntBEAAAAAAAOCCnTYIp/wDQAAoHL7DQu7sBEAAAAAAAJAzezbHEfwDQAB4wzp3NdnsBEAAAAAAAODjBqVH4vsDQACoV3rzkLLsBEAAAAAAAFhGzWyn0PsDQACIkEIPl2jsBEAAAAAAAAjesV4NxvoDQACQpDpgbxzsBEAAAAAAADgUPlsHx/kDQAAoj26ERQXsBEAAAAAAANiOkbRfNfkDQADgx019w1DsBEAAAAAAAPjIrUm3pfgDQACAiqpf6VzsBEAAAAAAAEjWGkrtpfcDQABY6e46GyLsBEAAAAAAAOiH2GDhpPcDQACofToeMxDsBEAAAAAAAOBSlba4BvgDQADQ/3ItWgDsBEAAAAAAAABPeFoZY/cDQABQ2e7Tk7DrBEAAAAAAAChOtRZmgfYDQAD4ViQmqIHrBEAAAAAAAPiyQ8JWa/UDQABIQx9Zw2PrBEAAAAAAAMCb1tucy/UDQAAQS0/Ck0LrBEAAAAAAAIDwrfK5jfUDQACY7s2ut+DqBEAAAAAAAMCX3Do0OPQDQACwbK6XDOXqBEAAAAAAALBOuHi8P/MDQADA0Tqsws3qBEAAAAAAAFCOhoKbBfMDQADY26JlqPTqBEAAAAAAAGDgWjOomfIDQAAAeZrTEf3qBEAAAAAAALBrZRHW+/ADQAAwdy78bvvqBEAAAAAAAMDea601APEDQACgLcQiC7nqBEAAAAAAAKBUDHgnffADQAB4/6UwtqbqBEAAAAAAAFjC8qfc4/ADQABANtBu05DqBEAAAAAAAADi+dyHnPADQABwsgAUaoDqBEAAAAAAALDmGaQZ6/ADQACY8NboVE7qBEAAAAAAAGDeNavWXvEDQAD4BiftRh/qBEAAAAAAANAY8Mx6B/EDQADAKXmfl/XpBEAAAAAAAMhrDcIdkfADQADYC95TL+jpBEAAAAAAAGi/WCDhjPADQACwnmnJqsrpBEAAAAAAAMjy3IorS+8DQAAQu8n5GMbpBEAAAAAAAFBUNqyp7O4DQADgwORGkbXpBEAAAAAAAJAnxKpIS+4DQACQk5Io0K7pBEAAAAAAAPic9L7xle0DQABAtcGJ6NfpBEAAAAAAAJBop2gvX+0DQAD4+i8A0snpBEAAAAAAAJhohIq+YuwDQACo8/YdNe3pBEAAAAAAAJhohIpAWewDQAAQqIpe8vzpBEAAAAAAACBCoxVbrewDQAC4lkjJCBfqBEAAAAAAAEAcJET5ouwDQACgMCjTaCLqBEAAAAAAANhXO4pzdOwDQAD4RxgGLCnqBEAAAAAAACBCoxUjIuwDQADY0Ol+birqBEAAAAAAAIibBj1h4OoDQAC43yEhSnbqBEAAAAAAAFj9EYYBa+oDQADwu+mWHXLqBEAAAAAAAIibBj0bJ+oDQAB4TLGjAWHqBEAAAAAAALi0GhL32OkDQAAAeXb51ofqBEAAAAAAAIibBj2zUuoDQABArNU/SpfqBEAAAAAAAHBp6xcAHOoDQACguC+1nqzqBEAAAAAAAABATpgwOuoDQADIxydk583qBEAAAAAAACh5dY4BOekDQAB4gO7Lmc3qBEAAAAAAAOgHcagqeegDQACAnImdBvbqBEAAAAAAAKCMF3VvU+gDQACw9X+D0kzrBEAAAAAAAKCMF3W3/eYDQAD4pp7E5EXrBEAAAAAAAGDxoP2mUeUDQABILhNhPXbrBEAAAAAAAAAKrJFNAuQDQABQJYHI9XHrBEAAAAAAAAAB0omX/OIDQAA4aV5GGoPrBEAAAAAAAMDYnyO7X+IDQACYMOMJAkzrBEAAAAAAAAhENBOT2OEDQADQKol8mKbrBEAAAAAAABC8voaWzuADQACoPtj9EwHsBEAAAAAAADDOzyugKOADQAAQP8+1EwHsBEAAAAAAADiv6qwWWN8DQAD4yK1JtxXsBEAAAAAAABBdUN8y590DQABAsU6V7+nrBEAAAAAAAID0YlWp8t0DQADYLalOlxzsBEAAAAAAAFAh4NQMNd4DQAB4vRlwJj/sBEAAAAAAAEign37wct4DQADoZ29ceobsBEAAAAAAAEh1OpD1FN8DQADIp8e2DLjsBEAAAAAAANgx9/q2Pd8DQAAYMYAXAfvsBEAAAAAAANgx9/qKtN8DQAC40op9RBftBEAAAAAAANCv1HiWEuEDQAA4SeSZJy3tBEAAAAAAALD7cSMcseEDQABQXhtJCHztBEAAAAAAALD7cSM8oOEDQADYG523EYDtBEAAAAAAABixGsBer+EDQACYLuEdaYrtBEAAAAAAALD7cSOkwOADQADI0NTK9dHtBEAAAAAAALD7cSOMUeADQACoa/NWWeHtBEAAAAAAACCns/E12NwDQAD4f+yP9O3uBEAAAAAAALhcbZ/iw+sDQADgxQJ6AZ7wBEAAAAAAAFhuaTUkLu0DQABwZmZmZrbvBEAAAAAAAPCFyVTBSO0DQABI6dK/JLXvBEAAAAAAANBfICLiRu0DQAAwzEGYJqnvBEAAAAAAAKjUCWgijO0DQAAQ7PgvEKTvBEAAAAAAAChATS1by+0DQACgYP91bprvBEAAAAAAABg74SU41e0DQACI0t7gC5PvBEAAAAAAAJBlUJo/xO0DQAAIbdObz4DvBEAAAAAAALC6O6TkaO4DQAAoXbeKHnHvBEAAAAAAAOATsvM2lu4DQABQdF34wXnvBEAAAAAAANjRMG1w++4DQADQHuNYQHDvBEAAAAAAANjRMG00Cu8DQAAAX+jwsGjvBEAAAAAAAJChCvqACe8DQADgZDmqC2DvBEAAAAAAABhqMXiYFu8DQACIfTuJCF/vBEAAAAAAANjRMG3sJO8DQADAaCqskGvvBEAAAAAAAKCRzyueOu8DQADgqx3FOWrvBEAAAAAAAIhvYd14N+8DQAAonrMFhGbvBEAAAAAAAOB2hT5YRu8DQACYOQg6WmXvBEAAAAAAABjq6SPwR+8DQAAAIsSVs2fvBEAAAAAAAOjWa3pQkO8DQAAYTMPwEWHvBEAAAAAAABCX4xWIfu8DQADg5uJve1LvBEAAAAAAAEhPkUPEje8DQABoNzP60VDvBEAAAAAAAEBhiQeUze8DQABoJ4Oj5FXvBEAAAAAAANjRMG3i8e8DQABowN+VhFXvBEAAAAAAANjRMG3sBfADQABIF3yaDlnvBEAAAAAAANjRMG10I/ADQAB4DPTBQljvBEAAAAAAANiEe2XeKvADQADATX/2I1XvBEAAAAAAAGiwqfOoOPADQABARYDTu1jvBEAAAAAAABgSMLq8OfADQACIeY8zTVjvBEAAAAAAAMDuO4bHPvADQACQv3tHjVnvBEAAAAAAAIhLVdriWvADQADQakjcY1nvBEAAAAAAAKDQvyCBTfADQAA4dUOOWkrvBEAAAAAAAKDQvyAzbvADQACw3f5DbETvBEAAAAAAAKDQvyDJufADQABYqh8AY0LvBEAAAAAAACARGsHG1fADQADIBaBRukTvBEAAAAAAAPBmDd5XBfEDQACQBdodUjzvBEAAAAAAAAjAeAYN/fADQADg7UEIyDfvBEAAAAAAAJC4ADRK1/ADQACwFwrYDjbvBEAAAAAAAFjLnZlg2PADQACooxzMJjDvBEAAAAAAAChATS1by/ADQABoXaPlQC/vBEAAAAAAACAFTyFXyvADQAAguqC+ZS7vBEAAAAAAABjdek0PyvADQACI2O4eoCvvBEAAAAAAAChcj8L1yPADQAAgwhTl0ijvBEAAAAAAAEiaP6a1yfADQAAAgnLbvifvBEAAAAAAAIA2OXzSyfADQAD45sWJrybvBEAAAAAAAHCVJxB2yvADQACAgefewyXvBEAAAAAAAHgbuAN1yvADQAAwthDkoCTvBEAAAAAAABhVhnE3yPADQAAw+WabGyPvBEAAAAAAAIjHRbWIyPADQADgwyXHnSLvBEAAAAAAAEirIXGPxfADQABgnSrfMyLvBEAAAAAAAJAehlYnx/ADQAAYbsDnhyHvBEAAAAAAAJjoLLMIxfADQABIizOGOSHvBEAAAAAAAMh0IVZ/xPADQABAhVypZyHvBEAAAAAAAEii0LLuv/ADQACgyjDuBiHvBEAAAAAAAMDYe/FFu/ADQABYvcPt0CDvBEAAAAAAAPi84qlHuvADQAAovASnPiDvBEAAAAAAAIBD4bN1sPADQACwsn3IWx7vBEAAAAAAAEh0z7pGq/ADQACwR+F6FB7vBEAAAAAAAIgq/BnerPADQACAkgILYBrvBEAAAAAAAFAnWRwNXPADQADwoBvDvg/vBEAAAAAAAFAnWRxRVPADQAAwn+x9LA3vBEAAAAAAAPjHQnQIfPADQADwUuqScQzvBEAAAAAAACAzUBn/fvADQAAw8YCyKQfvBEAAAAAAAFAnWRyLkvADQABwnrKn4AbvBEAAAAAAAFAnWRxtg/ADQACQV/3jP//uBEAAAAAAAJDAH37+m/ADQABwEW3H1P3uBEAAAAAAANA1zNB4gvADQACYk1D6QvjuBEAAAAAAAMjcfCO6R/ADQADQlZaRet/uBEAAAAAAANhXVwVqcfADQABA/wQXK9ruBEAAAAAAAHCvBb03pvADQADILHsS2NzuBEAAAAAAAJBmLJrOzvADQAAQqDej5svuBEAAAAAAAOif4GJF7fADQABQZ+4h4cvuBEAAAAAAAJhE2saf6PADQACAE3zT9MnuBEAAAAAAAPDiR1uC5vADQAAAHgCO1cbuBEAAAAAAAPDiR1sy+vADQAB48SOes8TuBEAAAAAAAPDiR1ueFfEDQAA4LTXo2snuBEAAAAAAANDj9zb9GfEDQAAYCwqDMs3uBEAAAAAAAHCPpQ9dEPEDQADIIeLmVNLuBEAAAAAAAPDiR1t63/ADQAAYH/b6gdzuBEAAAAAAAFDUmXtI2PADQABgu3uA7uvuBEAAAAAAAMiwijcy7/ADQAColUIgl/juBEAAAAAAAGiA0lCj8PADQAD4x0J0CAzvBEAAAAAAAIDZXlJKIvEDQAAIp0LkWAvvBEAAAAAAAIDZXlIkOfEDQACwGNn6KRbvBEAAAAAAAIDZXlK6KvEDQACIlTLYFhnvBEAAAAAAAIDZXlLcU/EDQACwywHx+S7vBEAAAAAAACAnF5ZNdfEDQABIGHkg9SnvBEAAAAAAACAnF5abrvEDQAAQEwIYZjHvBEAAAAAAADCzz2OUJ/IDQADAVGzM6yjvBEAAAAAAAPCdmPViKPIDQADAeXHiqy3vBEAAAAAAADD9S1KZQvIDQAAo9GxWfS7vBEAAAAAAAFhjCWtjTPIDQACwxJEHIivvBEAAAAAAAGBbP/1nDfIDQACAo6t0dw3vBEAAAAAAAOAi93R1Z/IDQACQvWw7bf3uBEAAAAAAABgVONkGLvIDQACgvTPaquTuBEAAAAAAAMATev1JPPIDQAAQ4PQu3t/uBEAAAAAAANiu0AfLGPIDQAAwwAXZstzuBEAAAAAAAKjLYmLzEfIDQADAX5M16tHuBEAAAAAAAIBjLYk14fEDQAAg3j9j1MXuBEAAAAAAAMCFVvd7v/EDQACwVDUWhrDuBEAAAAAAADBinwCK0fEDQADYrfNvl63uBEAAAAAAAIA9X7Nc1vEDQABg6q7sgrHuBEAAAAAAAKC80cgW//EDQACA0GzFWq/uBEAAAAAAAKh4XFSL6PEDQABIhT/Dm6XuBEAAAAAAAIB4Xb9gF/IDQADAZyRCI5juBEAAAAAAAFgZjXxe8fEDQADY/s726I3uBEAAAAAAAPj/OGHCCPIDQAAQonxBC4nuBEAAAAAAAHj3AN2Xc/IDQABAk1LQ7aXuBEAAAAAAAJiSrMPRFfMDQACY273cJ5fuBEAAAAAAAHBtvetULPMDQADwBoS9rZvuBEAAAAAAAIj6JHfYRPMDQADADI0ngpjuBEAAAAAAAHBtvetcYPMDQACQ039i7aDuBEAAAAAAAAhyiSMPZPMDQAAQUyKJXqbuBEAAAAAAAFjFG5lHfvMDQABooiQk0qbuBEAAAAAAABgZHZCEvfMDQADAdMx5xo7uBEAAAAAAAHBtveum2fMDQAC4xCA26IzuBEAAAAAAAHBtveuG6vMDQAAoqe9XmpLuBEAAAAAAALB78rBQC/QDQAAYQPhQopXuBEAAAAAAAKAnnrMFBPQDQABQCHJQwqzuBEAAAAAAAHBtvetW7fMDQACg2kO9La7uBEAAAAAAAAg2mzvS5/MDQADo6plD0rbuBEAAAAAAANB/D1671PMDQAAYVwdA3LXuBEAAAAAAAAAeGED40PMDQADAS3DqA7nuBEAAAAAAAPDPRUPG4/MDQAAgyEEJM73uBEAAAAAAALBoVyHl5/MDQACgVpi+18DuBEAAAAAAAAg2mzvcKPQDQADQ0Y+1Q8PuBEAAAAAAAAg2mzu8OfQDQACwOiIsadTuBEAAAAAAALiF56Vig/QDQABwEoPAytHuBEAAAAAAAKh7ZHPVnPQDQAAAiV+xhuvuBEAAAAAAAIC3eeOk8PQDQADgPgCpTezuBEAAAAAAAPjJMboE8PQDQAAwcGwgBvHuBEAAAAAAAGinH9RFCvUDQABwRzgtePHuBEAAAAAAADiNtFTeLvUDQACQWmH6XuPuBEAAAAAAAPjJMbr2dfUDQAAATNJ4X+buBEAAAAAAAPjJMbr8b/UDQABw0S/Hpu3uBEAAAAAAAPjJMbrUpvUDQADIc2UELv3uBEAAAAAAAPh2S3LADvYDQADYbDoCuPnuBEAAAAAAAPjJMbpC/PUDQAAQoePhygHvBEAAAAAAAPjJMbocE/YDQADoAt3X6wPvBEAAAAAAABgHl445D/YDQACwc9NmnAbvBEAAAAAAAPjJMbqA+vUDQADAjSjWbQXvBEAAAAAAAIgmUMQi5vUDQAAYIEPHDgrvBEAAAAAAAPjJMbp84PUDQAD4b6Roix3vBEAAAAAAADBC/G/mBPUDQAA4aGPdzCvvBEAAAAAAADBC/G9W4PQDQACwdyoxNjvvBEAAAAAAAKhLJViTfvQDQAAIC2zFX03vBEAAAAAAAIicvp6vefQDQAAAg6RPq1jvBEAAAAAAAAAydOygUvQDQACYc9TRcVXvBEAAAAAAAIChDivc8vMDQADAhqdXymLvBEAAAAAAACjc8pGU9PMDQACg6lc6H27vBEAAAAAAANBcp5GWKvQDQABowktw6nPvBEAAAAAAABhnDHOC9vMDQADg1avI6JDvBEAAAAAAACDGa17VGfQDQABoEB/Y8d/vBEAAAAAAAIhhwJKrWPQDQACA+zpwzujvBEAAAAAAAKB8Erxda/QDQABw6Kyd79/vBEAAAAAAAKB8ErxeiPQDQACQK5KUI+LvBEAAAAAAAKB8ErwUafQDQAC4FpXs1+zvBEAAAAAAAPh9/+bFSfQDQABg7e9sj+7vBEAAAAAAAKB8Erz4OfQDQAD4y8fgou3vBEAAAAAAAKB8Erx+SvQDQADwRhPHy/bvBEAAAAAAALBz02acRvQDQABwopbmVvjvBEAAAAAAAMCLvoI0I/QDQACQdqOP+fDvBEAAAAAAAEBdjLtwEfQDQABAkbcy6fLvBEAAAAAAAEBdjLusAvQDQABANl8SNQDwBEAAAAAAAEBdjLtrB/QDQADg9lNO/AbwBEAAAAAAAEBdjLtL6/MDQABon2eeLwnwBEAAAAAAAEBdjLvV6PMDQABYYpOxOxjwBEAAAAAAADDy64fY4PMDQAAwo1huaRXwBEAAAAAAAEBdjLsLs/MDQAAQf55fbB3wBEAAAAAAAEBdjLv/vvMDQAAoy7supSHwBEAAAAAAAEBdjLtBqvMDQADgVwazhibwBEAAAAAAAAjmIFuLFvMDQAAQJgX7xDvwBEAAAAAAAPDH4ykU9PIDQABgTdAhu13wBEAAAAAAAMCPw3Fbd/IDQACQyrW+U2HwBEAAAAAAAACq5gN8afIDQAAoJ/wcSl3wBEAAAAAAAACq5gP7NfIDQABAUxKuvmjwBEAAAAAAAACq5gPEIfIDQAB45DLNUX3wBEAAAAAAAEDecvVjE/IDQABYbw1slYDwBEAAAAAAABim7zUE5/EDQABgWWlSCnrwBEAAAAAAAFjaqbncwPEDQAA4pbxWQnfwBEAAAAAAAFDgxrNuqvEDQAB49hZEwnfwBEAAAAAAANAeL6TDg/EDQAAQ0hqDTnjwBEAAAAAAACANbmsLj/EDQAC4PnPWp3zwBEAAAAAAAFDMQdDRivEDQAAQwM3ixYLwBEAAAAAAAADaVrPOWPEDQABY6e46G4LwBEAAAAAAAKBWmL7XUPEDQABwmuleJ4XwBEAAAAAAADikUYGTLfEDQAC46gHzkInwBEAAAAAAAEh9WdqpefADQABI7j7HR4vwBEAAAAAAAPBEEOfhJPADQADIYfcdw5PwBEAAAAAAAFAn2epyKvADQADAh6Bq9JrwBEAAAAAAAMDUVppdD/ADQAAouRSBQKnwBEAAAAAAALAJmXkKJu8DQACwRnbJ7sHwBEAAAAAAALAJmXlLIe8DQABQGa6vdcnwBEAAAAAAAJiAmIQL+e4DQABgTKWfcMbwBEAAAAAAAACrYuC86O4DQACgVvR3eMnwBEAAAAAAAACrYuBezu4DQAAo+rQQYsnwBEAAAAAAAACrYuDet+4DQABYk8BZ/c/wBEAAAAAAAACrYuBCn+4DQABgR/Jajc/wBEAAAAAAAACrYuDweO4DQAAYjoZX8NXwBEAAAAAAAACrYuB4ae4DQAAoIeMGZ+LwBEAAAAAAAACrYmAcN+4DQADYMXTBc+fwBEAAAAAAAEBanDHMKe4DQAAwpwTEJOzwBEAAAAAAAMDTZMbbKu4DQACgctpTcu7wBEAAAAAAAHgBLzNsFO4DQADQqWQAqPLwBEAAAAAAAEAMrU7OEO4DQADARlm/mfjwBEAAAAAAAFiifq7v9+0DQACAPDLbAfjwBEAAAAAAAAgX8ghu5O0DQABYQndJnPXwBEAAAAAAAFiifi5i2O0DQABQDRQKefXwBEAAAAAAAFiifi7txe0DQABIzsjXavfwBEAAAAAAAJAsmWN5t+0DQAAYCJChY/fwBEAAAAAAALjx7shYre0DQAAIlbiOcfXwBEAAAAAAAAhtcviks+0DQADoOGItPvXwBEAAAAAAAFjE6SRbve0DQACQNo5Yi+/wBEAAAAAAAFhDqb2Itu0DQAA4HQHcLO7wBEAAAAAAAPhhhPBow+0DQAAwSddMvunwBEAAAAAAANDyA1d5wu0DQACIGK95VefwBEAAAAAAADgHCObose0DQABg7lpCPujwBEAAAAAAAJguzBH4o+0DQACwPmEJWuvwBEAAAAAAAJguzBG+ku0DQAAQbE4/DvHwBEAAAAAAAJguzBHTqu0DQAAAC2bLffXwBEAAAAAAAJguzBHIpu0DQABo7cIKxvnwBEAAAAAAAAjzV8hcme0DQADAX8yWrPrwBEAAAAAAAOiDns2qj+0DQAAoGhajrvXwBEAAAAAAAEDlX8srd+0DQACo9EwvMfbwBEAAAAAAALAyU1p/a+0DQAD43eaNk/LwBEAAAAAAAGj67IDrKu0DQAD44SAhyvfwBEAAAAAAABAyychZGO0DQABIRgckYe/wBEAAAAAAAAgAjj17zuwDQADYt5OI8O/wBEAAAAAAAJgwmpXto+wDQACA8nfvqOHwBEAAAAAAAHieeM4WMOwDQACoWaDdIeXwBEAAAAAAAJAnQpXOLewDQAD4kh8fK+/wBEAAAAAAAPDmqQ65+esDQACYRzfCouLwBEAAAAAAAJAnQhWS6usDQADg4p98E+bwBEAAAAAAALCf+07YZOsDQABQY4cVs8PwBEAAAAAAAFBhpYKKiusDQADomCzuP8LwBEAAAAAAAIAv9IGKv+sDQACoEX6zyLvwBEAAAAAAAPBhE5m5wOsDQACgBDbn4LnwBEAAAAAAAPiGwmfroOsDQACA91W5ULnwBEAAAAAAAJB4liAjgOsDQACAgLVq17TwBEAAAAAAAIAv9AGKmusDQADQMr+Yka/wBEAAAAAAALhrCfmgp+sDQADATxxAv6/wBEAAAAAAABhE/wx6uOsDQADAJjAcRqXwBEAAAAAAACCns/E12NwDQAD4f+yP9O3uBEAAAAAAAFDc6GZaodQDQACoZxHAq6/uBEAAAAAAAHj4YDyvPdUDQACAn9h8/gvwBEAAAAAAAGhVdzlYwt0DQABYmX1RXY3xBEAAAAAAAGhVdzmogd0DQAAA2zHP9rvxBEAAAAAAAGhVdzlo/d0DQACoOEs6mcvxBEAAAAAAAGhVdzkIMN4DQABg+t8XlyDyBEAAAAAAAGhVdzmgiN4DQABYlgg3GjfyBEAAAAAAAGhVdzmww94DQAC4e2qxBj7yBEAAAAAAAGhVdzkIt94DQABgkE0XD1HyBEAAAAAAAGDij6LO/N4DQAA4o61KImvyBEAAAAAAANDzp43qFOEDQACoCDcZVfbyBEAAAAAAADiZuFUQY+EDQABom+JxUR3zBEAAAAAAADBQGf8+w+EDQABwu9BcpyHzBEAAAAAAANAP6iKFMuQDQACIbYsyG9TzBEAAAAAAAGAOGHZ5OuUDQAA4IMRpAcrzBEAAAAAAACjZe7VQeOUDQACoy5aH9OnzBEAAAAAAADiK3cFEvOUDQAD4XiJPOir0BEAAAAAAAAg7xapBeOYDQABAQzhm2WP0BEAAAAAAALgru2BwjeYDQACo8+FZgnz0BEAAAAAAAFB8ZhkUrOcDQABouyFtppj0BEAAAAAAAIgw9hwo5+cDQABwALnF8K/0BEAAAAAAAEhV5ThS9ukDQAA4JD+JQBX1BEAAAAAAAKj2/zM6c+oDQAD4SGWk21H1BEAAAAAA" lonL="26.57878570936331" latT="61.32993943088717" LonR="35.78352046126446" LatB="58.42071593660957" color1="-1509916672" color2="1300234495" visible="TRUE" picname="" categoryid="1"/> </ROWDATA> </DATAPACKET> Categoryproblem_marks2.sml (518 bytes)
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <DATAPACKET Version="2.0"><METADATA><FIELDS><FIELD attrname="id" fieldtype="i4" readonly="true" SUBTYPE="Autoinc"/><FIELD attrname="name" fieldtype="string" WIDTH="256"/><FIELD attrname="visible" fieldtype="boolean"/><FIELD attrname="AfterScale" fieldtype="i2"/><FIELD attrname="BeforeScale" fieldtype="i2"/></FIELDS><PARAMS AUTOINCVALUE="478"/></METADATA><ROWDATA><ROW id="1" name="test" visible="FALSE" AfterScale="3" BeforeScale="17"/></ROWDATA></DATAPACKET> | ||||
|
|
При попытке обновить поле mGeoWKB, когда данных более 8000 байт, вываливается сообщение от сервера: "TODBCStatement - TODBCLib error: [HY104] [Microsoft][ODBC Driver 11 for SQL Server]Недопустимое значение точности (0)\r\n". Где тут грабли (в SAS или в настройках сервера), сходу понять не удалось. В MySQL сталкивался с похожей проблемой при попытке вставить более 1Мб, но там быстро нагуглился параметр в конфиге, который за это отвечает - max_allowed_packet. В MongoDB есть лимит на размер документа в 16Мб и это никаким конфигом не изменишь. В PostgreSQL, по-моему проблем с лимитами небыло. |
|
|
Ага, похоже таки проблема в обёртке над ODBC в mORMot. Сделал небольшой фикс и всё заработало. Сейчас надо обсудить этот фикс с разработчиками фреймворка и посмотреть, что они скажут. |
|
|
Фикс одобрили, тестируйте следующую ночнушку. |
|
|
Zed, спасибо за внимание к этому тикету. Теперь при обращении к пустым таблицам возникает ошибка EMarkSystemORMErrorr: MarkSystemORM: ID is empty! Пробовал удалить все таблицы. При обращении к пустой базе таблицы создаются снова и возникает такая же ошибка. |
|
|
Не воспроизводится. Пробуйте тестовую версию, которая пишет логи: https://yadi.sk/d/Y1EO3soxkHGSs |
|
|
логи приложены: http://www.sasgis.org/mantis/file_download.php?file_id=1973&type=bug |
|
|
У вас оно почему-то не может ни прочитать, ни записать имя пользователя в таблицу. В обоих случаях вываливается с ошибкой: > [HY104] [Microsoft][ODBC SQL Server Driver]Недопустимое значение точности (0) Попробуйте другой драйвер, например, у меня в сообщениях (в других багах) фигурирует "SQL Server Native Client 10.0". |
|
|
Или добавьте юзера 'sasgis' руками, может заработает. |
|
|
И вот ещё заметил, в самом начале, при попытке соединения: > [01S00] [Microsoft][ODBC SQL Server Driver]Недопустимый атрибут строки соединения (0) что-то у вас там лишнее/неправильное в строке соединения? |
|
|
> что-то у вас там лишнее/неправильное в строке соединения? Проверил: строка соединения скопирована с предыдущей работающей ночнушки: Driver=SQL Server;Server=sql01; Database=SASPlanet;Integrated Security=SSPI > Или добавьте юзера 'sasgis' руками, может заработает. добавил пользователя с помощью предыдущей работающей ночнушки - не помогло. > Попробуйте другой драйвер попробую и отпишусь |
|
|
>с предыдущей работающей ночнушки Это какая версия конкретно? Через DSN подключаться пробовали? Я только так и тестирую. |
|
|
>Driver=SQL Server;Server=sql01; Database=SASPlanet;Integrated Security=SSPI C такой строкой, у меня тоже не работает, но работает с драйверами: SQL Native Client SQL Server Native Client 10.0 SQL Server Native Client 11.0 ODBC driver 11 for SQL Server Для этих драйверов параметр "Integrated Security=SSPI" является неизвестным, о чём и выдаётся сообщение (и у вас в логах было это сообщение). Чтобы использовать Windows авторизацию, нужно добавлять параметр: "Trusted_Connection=yes;" Рабочая строка подключения: Driver=SQL Server Native Client 11.0;Server=HOME-PC\SQLEXPRESS;Database=sasmarks;Trusted_Connection=yes; Драйвер Native Client 10.0 устанавливается вместе с сервером MS SQL 2008. Все драйвера можно скачать с сайта Microsoft и установить отдельно, что я и сделал для тестов. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 04-11-2015 08:55 | sheavy | New Issue | |
| 04-11-2015 08:55 | sheavy | File Added: problem_marks2.sml | |
| 04-11-2015 10:03 | sheavy | File Added: Categoryproblem_marks2.sml | |
| 04-11-2015 10:19 | zed | Note Added: 0016717 | |
| 04-11-2015 11:10 | zed | Note Added: 0016721 | |
| 04-11-2015 11:10 | zed | Assigned To | => zed |
| 04-11-2015 11:10 | zed | Status | new => confirmed |
| 04-11-2015 14:38 | vdemidov | Target Version | => 151111 |
| 05-11-2015 18:04 | zed | Note Added: 0016733 | |
| 05-11-2015 20:11 | zed | Status | confirmed => feedback |
| 06-11-2015 14:05 | sheavy | Note Added: 0016743 | |
| 06-11-2015 14:05 | sheavy | Status | feedback => assigned |
| 06-11-2015 18:21 | zed | Note Added: 0016744 | |
| 07-11-2015 15:27 | zed | Status | assigned => feedback |
| 09-11-2015 07:51 | sheavy | File Added: SASPlanet 20151109 103224.log | |
| 09-11-2015 07:52 | sheavy | Note Added: 0016766 | |
| 09-11-2015 07:52 | sheavy | Status | feedback => assigned |
| 09-11-2015 08:14 | zed | Note Added: 0016767 | |
| 09-11-2015 08:15 | zed | Note Added: 0016768 | |
| 09-11-2015 08:17 | zed | Note Added: 0016769 | |
| 09-11-2015 14:07 | sheavy | Note Added: 0016770 | |
| 09-11-2015 14:22 | zed | Note Added: 0016771 | |
| 09-11-2015 14:30 | zed | Note Edited: 0016771 | |
| 09-11-2015 14:59 | vdemidov | Status | assigned => feedback |
| 10-11-2015 10:58 | zed | Target Version | 151111 => 191221 |
| 12-11-2015 14:59 | zed | Note Added: 0016789 | |
| 12-11-2015 15:00 | zed | Status | feedback => resolved |
| 12-11-2015 15:00 | zed | Fixed in Version | => 191221 |
| 12-11-2015 15:00 | zed | Resolution | open => fixed |
| 18-11-2015 09:50 | vdemidov | Target Version | 191221 => 160606 |
| 18-11-2015 09:50 | vdemidov | Fixed in Version | 191221 => 160606 |
| 18-11-2015 09:58 | vdemidov | Product Version | .Nightly => 151111 |
| 08-08-2025 13:22 | zed | Category | Баг => Баг / Bug |