KIX - Forum

Community => Bekannte Fehler | Workarounds => Thema gestartet von: iis-mma am 29.11.2021 14:05:44

Titel: SQL-Fehler in Log bei Ticketsuche
Beitrag von: iis-mma am 29.11.2021 14:05:44
Hallo,
seit dem Update unserer Kix-Installation auf 17.14 erscheinen bei jeder Ticketsuche mehrere Fehlermeldungen im Log /opt/kix/var/log/kix.log:
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][407] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? AND is_last_version = 1 LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][436] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? ORDER BY id DESC LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][455] No such config item version!
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][407] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? AND is_last_version = 1 LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][436] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? ORDER BY id DESC LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][455] No such config item version!

In diesem Fall habe ich lediglich in der Suchleiste oben in der Agentenansicht nach "foobar" gesucht. Die Suche scheint trotz diesen Fehlers zu funktionieren.
Titel: Re: SQL-Fehler in Log bei Ticketsuche
Beitrag von: Tino Voigt am 21.12.2021 12:00:45
Hallo iis-mma,

kannst du einen Screenshot deiner Suche machen? Hier wäre es gut, nach der Suche auf "Suchoptionen ändern" zu klicken, damit die Suchkriterien dargestellt werden.

Viele Grüße, Tino Voigt
Titel: Re: SQL-Fehler in Log bei Ticketsuche
Beitrag von: iis-mma am 10.01.2022 12:02:23
Hallo,
anbei der gewünschte Screenshot.

(https://forum.kixdesk.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAmkAAAIlCAYAAACO62/FAAAgAElEQVR4nO3dTWtj2YE+cH2H7E0W+QhZ1qIX/Q1mZ21Ck13R455VvGhwL7yaYvhDAsZQabXpNyYedVUPeApDNxSuFE0zMVVgCtO4YjK1mHFwQzCYkOX5L5qjOjq+9+rKku0j3d8PHtIl3TddXVlPzr2SehsbG2FjYyN8+eWX4dGjR2EwGIiIiIjILefRo0fhyy+/DLGb9TY2NsKjR4/CV199FX788cdwcXEhIiIiIrecH3/8MXz11Vfh66+//qmkffbZZ+E//uM/7nzDREREROQi/OEPfwiffvpp6O3u7oa//vWvd75BIiIiInIR/u///i98/fXXoTcYDO58Y0RERETkbT7//HMlTURERKS0DAYDJU1ERESktChpIiIiIgXm2iXto48+Cv1+f5Tf/va3c9uofr8f/vSnP935zhERERG5q1yrpH300UdXStn7778/t6KmpImIiEjXc62SVlWi/vSnP4V+v187TX7/xcVPxS6OxH300Udj837xxRdjI3Wnp6e1877//vt3viNFRERE9vf3w7/+67+Gs7Ozsds+/vjjqZd1rZL2/vvvj5WqqkwqafnI2/vvvx+++OKL0bxp8frtb387tr583i+++EJRExERkTvNq1evRgNIv/nNb8LZ2VnY398f3TZtUbtWSTs9PR0b5aoa6WoqaVWjanG5cd79/f3aeasK2fvvv+8UqYiIiNxpfvOb34y60T//8z+P/vvXv/51ePXq1VTLmvnTnWlDzE9Z1pW0/f39xpGvpnnz06Bp0mInIiIicts5OzsbK2rXLWgXF3P8Co44uhbL1U2WNKc2RUREpNQ8fvx4rKTFU5/TLmfqktZUsNJTjvnIVhxxu7ioP90Z0+ZUaX56VUREROSuk55hnLWoXfvTnfkHB/IRrvxrOuKnMdN/xw8KXFyMfzigzYcO0vXH+12TJiIiIneV9IMDv/71r8N///d/j536/N3vfjfV8ub2Zbb56Fr+4YJ0JC2m6Ss4pvn6DgVNRERESsjvfve7sWvQ4jVqd/LBARERERF5m6rTmrdyTZqIiIiI3HyUNBEREZECo6SJiIiIFBglTURERKTAKGkiIiIiBUZJExERESkwSpqIiIhIgRmVNBGRZcje3t6db4OIyLzSGwwGAQCAcihpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShoAQIGUNACAAilpAAAFUtIAAAp0KyVtOByGnZ2dcHZ2Nnb72dlZ2NnZCcPhcKbl7+zshJ2dnZmWAQBQklspaS9fvgw7Ozvh+fPnY7c/f/487OzshJcvX860fCUNAFg2t1LSLi8vK4tUvO3y8jKE8LbMxeTlbX9/f1T20nnzZccRujRxHVEc3UuXkY/o5dvz+vXrymXk6wMAmNWtXZMWC1YsOq9fvw47Ozthf38/hBDGileadPQtLiMmlqq0HKWlrWrauuXk09RtT1oc06KXJj4mAIDrurWSFktZLF2xBL1+/XqsWMURr/S2eC1bOpKWmjSCld6fjnpFccQslrS6kbXhcDh2WyxpsbjN6xo7AIBbK2n5acn0v/MCF8XyFEffYknLP4BQV9Lyka6mdaXlKk5Tl1gk4/LTU6lKGgAwD7f6FRyxZOUjYtOWtPz6sqrTnWlRmndJiyUxlrS65QAAXNetlrS8/MSyM+l0Z7ytTUmLxS4/BVl1zVrU9nRnTkkDAG7KrX+ZbdWF/CFM98GBppLWNAqWL6fpgwP5NFXbraQBADfl1kta03ejtf0KjqaSlk4XlxGXm17Lll6vFpcxqTjmn9pU0gCAm9K5n4Wq+tSoT2UCAKXpXEkLof77zWb95QMAgHnpZEkLIVwpaPmnPQEA7lJnSxoAQMmUNACAAilpAAAFUtIAAAo0dUk7PT0VERERWagsIiNpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0lh6g8FARGSmwF0YDJQ0lpzjG7ppMBiEN2/ezJz8b8hdF8bSw/woaSw9xzd0002WtIuLC6mIv7fzpaSx9Bzf0E1KmpK26JQ0lp7jG7pJSVPSFp2SxtJzfEM3KWlK2qJT0hbMwcFB6Pf7oxwfH8+0vOPj49Dv98NwOJzTFtav4+Dg4MbW0cTxDd2kpF2E9fX1cO/ePSVtQSlpCyYtVJubm6Hf78+0PCUNWFa3UdL29vZCr9cLq6uro9tWVlbC3t7enRc0JW3xKWkLJJadzc3N2vtiEdre3g79fj+cn5+HEEI4Pz8fG4GLpSzOt7a2duW+tbW1sXX1+/2wvb1dubw4ohdvjwWy3++H7777bmzbhsNh5bbk98VlxMcQtzUm3h5HF+tKoOMbuuk2S9rKyoqSpqTNnZK2QPJilJpU0tKClZaavPilo3PpMtLlx+2Iy0unS7exatvi/XG74rzpdLG0pWUszhfvS+dT0oAqdSXt+++/H/tbGvP06dNrl7T19fWwvr5+paTF+9MiF2+Ly+j1eo3T51lZWRlNEwtYnO/evXtjt6clrW7ZW1tbo9t7vV7Y2tqauO35epS0m6GkLZi6UaimkhZLTNX1a3kxqipNBwcHo/Wm25CPng2Hw7GRtHwdaYnKr607Pz8fLTcvcFX3TXMK1fEN3dQ0kvb48eOxv0GPHz+eaSQtlqe8pPV6vXB0dBQuLi7C6upqWF9fbyxpVdM3jVzFeeMy9/b2wtHR0Wg5aUmrWnY6bdz2WNKatj1fj5J2M5S0BVR1qrGppOWlKlVX0tIRuM3NzbC5uTkaOcsLUzqylo+ypetIR+6qRuvalLQ8ba6lc3xDN0063RmLWlNBm6akra6uhq2trVFJS0eiYlZXV2tLWt30eTHLR77SefNlxpJWt+y4veko3dbW1tTbrqTdDCVtgcUSk5afppG0qlGnSSUt/nttbe3KNWVNI2l1Ja1NEYvLbSpw03B8Qze1uSbthx9+mMs1aRcXF+Ho6Cjcu3dvrKRVnbJsKml1pzjzedORr7YlrWrZTSVtmm1X0m6GkrZAYlHJy1J6zVYsR/GDAPmIWAjjxWxSSctHvkIIV9ZVdU3apJIWH0N6urPNNWlV63RNGlDlNj84EP8dr9VKT1/G04fxGrF0nvT0Yd30dSUpnm5sU9Lqlp2fskynmbTtStrNU9IWTCwnMWkxSe+b9OnOWHYmlbQQxgtelC+v6tRnlI/ypZ8kjR9UiKNn6WnN9Pq4dDnpad4QfHAAqHYXJS0vXflpw1i60gvv20yfJs6zsrLSeiStadmrq6tjHxBo2hYl7XYpaRQjL4ybm5thbW1t5uU6vqGbfJnt9Mk/CDBt/L2dLyWNoqTfr1b3YYdpOb6hm5S0dokjc3Ujd0ra3VHSWHqOb+gmJe324+/tfClpLD3HN3STkqakLToljaXn+IZuusmSJvVhfpQ0lp7jG7rppkoa3BYljaV31/+vUkQWP3AXBgMljSU3GCzW9SNejwCEoKTRAUoaAItISWPpKWkALCIljaWnpAGwiJQ0lt5Nl7T8t+yUNADmQUlj6aUlbWtrK6ysrFQWrfgjxNMWLiUNgJugpLH02pQ0I2kAlEZJY+m1KWlbW1ujHxheXV0d3b6ysjK6fWtr68q09+7dG5W0+CPFcUQuLXC9Xm+03qbplTQAIiWNpTeppB0dHYVerxeOjo5Gpzv39vbC1tbWWIFaX18fTbu3t3eliO3t7VUuK/736upqWF9fb5xeSQMgUtJYepNKWn5bXqbSkbWq+fPTnbGApaNo6Shd3fRKGgApJY2ld92Slp8KXV9fn7qk1X1IQUkDYBIljaV33dOd8fRmLG6rq6uNpzurSld6LVs8ZaqkAdCGksbSy0tafgqy7oMD+enKqmWkHxyoKl35MpQ0ANpS0lh6fnEAgEWkpLH0lDQAFpGSxtJT0gBYREoaS09JA2ARKWksvcFgsHABACUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJY3O+fOf/yd8/vnj8P/+38et8vHHfwh//vP/3PVmA9AxShqd8/HHf2hd0GI+//zxxOXO81cDLi8vw2AwCJeXlzMtp2nZZ2dnc1/2XWxH03LOzs7m9lycnZ3NtM0nJydjx8eLFy9m2q5FU8pxB4tESaNzYvGa5/S7u7tjb7ovXryYqRwoafNRSkmrOh66WNSA6ShpdM68S1pdoRoMBuHk5OTK/VXT5yNwcZr45p6+oe/u7oaTk5MQwtvRmarlxCIRi8qTJ09G603vz0d4nj17NlpenDfdlrrtriuUdcvPtyN9rHHf5aoee7qc/LHG7O7uTv085NPVlbQ2+6Cq2MVtvby8nHnbpp1v2ufo2bNnV47D9Lb8uJm0H9PHP82x1bQ9sIyUNDrnJkbSYimoKhaT3kjT4vHixYvw7NmzsTejEMbL2LNnz8beKOM06WheWmDim2FcR/5mWVXY4ral88U3xnS78/VVqVt+VfnJ91mu6rFXlbS4zelIWpvnoerxNJW0NvugaTQvPvezbtu08037HFUdh6knT56M/Z+ISfsxrnPaY6vt9sCyUNLonJsoaSFcHY3IS1HVG2nVG/ikkZWTk5OxYpaWh3QkIhaAdMQmXVacL1933bZN2u60bKbz1C2/qvxMOr3b9NjTkhaX07akNT2eupLWdh+cnJyE3d3dysfTpqS12bZp50u1eY6aRupevHgRnjx5cmV/N+3H6x5bbbYHlomSRufcVElLxTeaqgIy6Q0pnyb/9+Xl5ej0XXzzr1pOHN1oKmkhXD3NmJbBvFzk252n6tRT3fKbTn81jUrmj32eJa3q8UwqaZP2wawjaW22bdr5pn2O6kpR/tja7sfrHltKGl2jpNE58y5pJycno5GE1HVHO/Jpqv4d37Tya4emHUmru6/NSFrd6FCqafl5SWt6/Km6xz5rSat7PE0lrc0+iNucltH0eZnHtk07X6rNc9R0HKbPX9v9eN1jS0mja5Q0OucmRtLykZ+ma7vyi6TzUa02F7nHa+DSN8hJ16Q1lbQo/XBBvt1V1w3l137VXRxftfymkZV4X5X8sbctaZOeh7rHU1fS2u6DdF1xe3d3d68cM9fZtlnmm+Y5qjoO0+vQUm32Y77dbY8tJY2uUdLonJs63Vl1uihKr1fL30jjG01Melvdm1HdV3yky8lPI9ad7kw/CRnLUv4GORgMrryR5uurOj3ZtPx8O/JPC1aVnarH3lTS0m2c9DzUPZ6mktZ2H+TrTtefF+tptm2W+aZ5jqqOw1g088fUZj+GcL1jS0mja5Q0Ouc2rklbRk0XwHN9CoZjC+ooaXSOktZOPsJnxIJ5cWxBO0oanfP73//71D8L9dlnk38WCgDmSUmjc/785/8Jn33W/gfWf//7f/cD6wDcOiUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJo1PyL9CUtz+ZBEBZlDQ6ZTAYhIuLC0ni9Q9QJiWNTlHSlDSARaGk0SlKmpIGsCiUNDpFSVPSABaFkkanKGlKGsCiUNLoFCVNSQNYFEoanaKkKWkAi0JJo1NKKml7e3uh1+uFXq8Xjo6OlDQAxihpdMqkkra3txdWVlbGbltZWQl7e3thdXU1rK6uzq0c3bt3L6yvr4/+vbW1FVZXV8PR0dGVbVDSALpHSaNTZilp8y5HN7VcJQ1gOShpdMosJW19fT3cu3dvdJry3r17o/+9uLgIq6uro9OX8fY4bVxWr9cbjcq1mS6OsKXL3draGm1rvC1uc922KWkAi0dJo1PalLS0EMVUlbS9vb1wdHRUeU1ZvL+pfKUjaXXT5ctfWVkZlbT09tXV1bC+vt5q25Q0gMWgpNEp8xxJqypeFxfj15rNWtK2trbGtieWtKoyubq6OnHblDSAxaGk0Sk3XdLiNPnI3E2UtKoPFyhpAMtDSaNTbrKkVc2bTpueimwqaU2nLNNr0tL/jgVRSQNYHkoanXKTJS1erJ9+ICCe/kwv5q8qaU3TpR8yqCp2MUoawHJR0uiUkr7M9jq5iS++9foHKJOSRqcsYklLR+jSL79V0gCWm5JGpyxiSbvpeP0DlElJo1OUNCUNYFEoaXSKkqakASwKJY1OGQwGUhEAyqOkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQoFspacPhMOzs7ISzs7Ox28/OzsLOzk4YDoc3uv7bct3Hsr+/f2XfTCvu46q8fv16tH07Oztj25v+e17bAgDM7lZK2suXL8POzk54/vz52O3Pnz8POzs74eXLlze6/ttynZIW98FtlLSq7U1L2ry2BQCY3a2UtMvLy8pRm3jb5eVlCOFtmasrF/v7+6OyF6f5r//6r8pl7O/vj+aLBabtetKRv3S6XFqMXr9+XVnSmtYVH09Mus2TtrFuW5o0jaTNsi1Vz0vc1wDA9dzaNWnxjTy+wcdSE8tA+gafJh1ly4vEcDgcFYi43HSaEN4WxGnWUzcqlRaXfFvSbYomrauuGLXZxtxNlbTrPi8AwGxuraTFUhZPecY3/9evX4+KVP7mPhwOx25LR2yiONoVb0vLwtnZ2Wi9L1++bL2eWHhiEcmvnUtH2PLHF6dpu678FGPb+XJtimVTSZtlW6qeFwBgNrdW0vJTnul/x4JTl3jqLJaB/JqpWBrSwhZLVlo82q4nPz0atzcWk7xwNk0zaV15MWo7X+4mStqszwsAcH23+hUc8c08H3mZVAbim3+cLy8qsVykJWM4HIb9/f2xUZ+266k6dTjvkhbXNW0xqitCs57unGVb6p4XAOD6brWk5W/6k06r5erKQL7cEMavpYplqu16JpW0qg9CxGvjJp3uzLU9xTjJTZS0WZ8XAOD6bv3LbGMxyN/421yI31QG8tN7aXFLR5/arGdSSZt2e5umSctk3PY28+XmWdKm3RYlDQDm79ZLWtN3o+WfJEyvpwqhuQzE++Jy6772o8162pS0dLqdnfqv4Ji0rvRDCE2fDM3ny82jpF13W5Q0AJg/PwsFAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUaOqSdnp6KiIiIrJQWURG0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKSx9AaDgYhMCFCewUBJY8k5vqGZ1wiUSUlj6Tm+oZnXCJRJSWPpOb6hmdcIlElJY+k5vqGZ1wiUSUlj6Tm+oZnXCJRJSaPW2tpa6Pf7V27v9/thbW2tdr7j4+PQ7/fDwcHB2H+HEML5+XnY3NycedumWU7V8f3OO++EXq8XfvWrX11r/X/5y19Cr9cLf/nLX641P5Qkf418/vnnod/vN+bzzz+/o62F7lDSqDUcDscKVghvC9hwOKydr6mk9fv9uZS0aZZTdXz3er2Z1q+ksUzS18izZ8/C5uZm+Pvf/147/d///vewubkZnj17dhubB52lpFHr/Pw89Pv9sL29Pbpte3s79Pv9cHx8PLo/5vj4OIRQX9LiyFw6Ehfvjzk/Px+7Pa47XW++nIODgytlMpUf371eb5SnT5/W3tY0fSxpv/rVr0b3ffLJJ6N5Pvnkk7H54ojd06dPQ6/XG43kQQnS18ijR4/Co0ePJs7Tdjrg+pQ0GuWnPNfW1sLa2tqVAhdL1Pn5eeuRtLiMOCoXlxHFf8cRvbQspsuZtqSFEMYK189//vOwsbERQnhbruIIWd19saS98847IYS35SvOly4/nS9OlxY6uGtKGpRJSaNRLEjHx8djpzrT20MYL1xtS1pcRj56lpatdJQtNY/TnU+fPq08bfnzn/88fPLJJ63uS0fd3nnnnbCxsXHlFGi6nLzMQQmUNCiTkkaj9LRjWszygpWOrE1b0vKk17vF0bR0FC1fziRNJS2WplQsW033VRW4eF8IIWxsbIyd7lTSKFlVSXv06FHthwbSaYCbo6QxUTzFGRNCuJGRtFx+vVpcV76cSW5rJC3elxcxI2mUzkgalElJY6J0xCuOcs3zmrSqZYTw9nq4OF36tR+lXJOWfyAgLWJR/JCAkkaplDQok5LGROmIVjqalX+6s+rasrykxSIWrzGrGy3Lv/4j/jv/kEGcZpaSFv8966c78+vT0k991o2yQQmUNCiTksbSc3xDM9+TBmVS0lh6jm9o5hcHoExKGkvP8Q3NvEagTEoaS8/xDc28RqBMShpLz/ENzbxGoExKGkvP8Q3NvEagTEoaS28wGIjIhADlGQyUNACA4ihpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJY3OmOdXDlxeXobBYBAuLy+v3Hd2dla5/DjP2dnZTOuexzJycdtOTk5Gt6WPo+4xpfOenZ017pcmTcu/jmfPnoXd3d0bXUcqPu6YfN3TqvqKjDb7dJbH+OTJkzAYDMKzZ8/G/rtJ1XHTtE3psRJvn+ZYqTrWJr0WrntMVm3rTap7LHE7Qghhd3d3NM11H9c8zGvdbf923Mb+L5WSRifs7u6GFy9ejP794sWLmV70d/kH5SZK2osXL8KTJ0/G3pTblrRUKSWtqgC8ePFiYumYZV3pc/LixYuZitp1lzfLfkzna7uMquOm7TbNWtKmnWdRS1qdZShpbZeppHX0wdMNdS/+OAKQ3181fT4CF6eJZS/+dzpt/qZa9f8anz17dmX+uu1Pp0//mFeNtkyz/BB+KrHp/2PPH0f63/EPZhxtmfS44ihL036u2mezPq68mD958mS0Lemy85GJtvusbj3p7XXP0yT5c1z1JlW1f5qepzbz5ZlUGqqOm3y96TY1jaQ9efKk9fOfj6Q1PXdNr9UQQjg5ORlbVyyc6fInvaarjulJx9Ok1/V1lp+PaFbtw6rjIt03k5YzaZ9Oc9y1/dtRt/+7YDBQ0uiA+Aej6rTMpJK2u7s7mi+OxqR/UEJ4+4c+hHanO5vmz6UlIE4X/5hX3Zeuq83yLy8vw5MnT0IIP50mjI+1biQt/ndevtLHFZeXvhE37ed8n83jccXTdlFcV9Wy8ze9SctO913bMpMfQ03yZcYRq3R5Vfun6Xlqmi9fZ5vHNOm4qTqO6kras2fPxvbJpOe/qaTVzVP3vKaPtep4aBpJa1uiqtbb9LqeZvlVr7WmfVj3+s3XmW7ndf7+tTnu2v7tMJLW0QdPt+T/j7nNCE/VH4dpC0c6X/4HqWn0ru72pjeO+Ae17fJD+OkPb/oHNP7hnVTSJo1uRE+ePAkvXrxovc/m9bjyZT558qRy+ussO2ozTd0x1CQ9TvPRh6b90/Q8Nc0X1zlNSZt03FStt6r45AWtzfNfV9Kaykzdfamq+WYtaW3uq9vnbZZR9Vprc4xM+xpKt6nNa7nNcdf2b4eS1tEHT3el1xHNUrhuuqTV/YFL3zjyTCpEufy0VFMxS/+7qaSl67luSZv1ccV9dXJyMioUVfuzzfY1mVRorvMGky+zalShav+0KWlV8+XrbFPSJh0305S0dP+0ef7nVdJCuHqq7zZKWtPr+rrLj89Jehw0HSPpfPn0VaOgbbdrmuOu7d8OJa2jD55uODk5GTtVFLUZQbnrktb0/7jPzs5qr9GYZflNozLpfzeVtPTNZtr9PI/HFcVTnnEUrenxXrekxTeSqtvz/dhWVUlKn5e6/TOppDVd0zNNSWtz3LQtaZeXl2OngNs8//MqaU2jSjdZ0ppe19Muv+q11uYYqTuu5/X3r81x1/Zvh5LW0QdPd6T/7zCE8WtP8vvj/7NO74t/OOKn7G6rpIXw0x+q/NqPuD3p6aq2o4Op/FqnEMLo9NMsJa3u1Ffdfs732ayPK4rzpm8Sk65Jm7akpduX7tf8Ivj8GGqSLy/fj3X7p+l5apovX+ekktbmuJmmpOXrnPT8z7ukRemHYdqUtLjdVcf0pOOp6XU9zfLrXmuTjpE43cnJydjxGJebrv86f//aHHdt/3YoaR198HTLYFD/vVPp9Wp5SYt/PGLS2+r+AKfTRtctaeny4qhQ+sc83bY219mlqj6ZmF7Ymz6O+N9tS1o6fZv9nO+zWR5Xvu/yC/XTZcfta/NGXyc/pVP3KcCqY6hum/M0feIuva/ueWozX17S6rax6bipWm/6mmsqC22f/3me7kxP28bCkl8vlW5Pru6YbnOsNr2u2y6/7rVWtw+rnp90Gflypv37N81xN83fjrr9v+wGAyUNYKKb+I61m1jmvC3CNsKyUtIAWlDSgNumpAEAFEhJozPiNQ/L8vuUubYXOueqrmW5a/PY39Ooum6tyxcrA2VQ0uiMZft9ynmtS0kLlRcqK2nAXVPS6IxF+X3KXPqprrje/BNf6brST5B1WLAAABR2SURBVBpWfdVDui1tfwt0mu3ITfO7gG0/MTrNMtr8FmecLt1feUmr+43H6+ybWbcX6AYljU64vFyc36fMpYUgLqPpNwonne68zm+BTrMd+X5Pb8//Petv+rVZRpvf4ozrSr+YNt+H6X6q+p69tvtmHtsLdIOSRics0u9T5qpGuqq+26tNSav7rqa6eep+27FpOyatL2paX9v93WYZbb5TLV9X/nxNelxt9828thfoBiWNTlik36fMzbOk1ZWEdJ66bbpOSat6rPkoZtX62u7vNsuYpqSF8PbaxXxf1f3G4zT7Zl7bC3SDksbSq3qzK/n3KXO3OZLW9rcdm7ajSb4/5vGbfvP4nc+q5ac//F13PFynpM3rd0mB5aeksfQW7fcpc/MsaXG90/4W6DTbkZr0u4Cz/qZfm2Vcp6SlI17pv6P0AyXT7pt5/S4psPyUNJbeov0+Ze46Ja1qXfkyB4P2vwU6zXbkmn4XsG590+zvScu4TklLtzuq+43H6+ybabc3L7dANyhpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlqak7e/vh/39/RBCCC9fvgw7OzuV05ydnbVa3s7Oztgy8n9PMhwOp5p+2uVW5fXr1623fZp9AQDcvqUpaZM8f/487OzsXLukTesuS1oufyzT7gsA4PbdSkk7OzurLBUvX74MIVQXmp2dnTAcDhuXMWkdl5eXIYSfRo3S2+MoUtM2tR2Nqtue+JguLy9rpwnh7ajfpKKVL7dJ07ZX7Yu22xLnjSUv3ccAwHwtTEmrmj/enxeh/P6bKGn5MvPtrRvxSktRWnaqtqHKTZW0NtuSz5s+XgBgvm79dGdaBqJJJS0WqrTgTDLNKb6qbWr6d9yetKTEZcTRp/iYYsnJ54nFMi86w+Gwsfy0KX+THku+L9puSzqSBgDcrFstaa9fv648TdZmJC0vJ3VFIZ8uqitpddvUVHTiPE1lJT3dWfWY0vVWpe404k2UtLbbEkuaa9kA4ObdWklLTy/m1zrlhaZuZCeEq6c9Ly8vK6dvU9KatmleJS1fZtuSVleEZj3dWbUv2m5LLGmuQwOAm3crJS29ZqzqeqtYPGIZiBewN532S4tGnD4/tdjmFF/dNrU53Znen2/DpJLWVESb3ERJa7stShoA3J5bKWn5pwbzU3RVF+GnpaHuIv9YGJpGgqL0urP9/f2J2zSp6NRtcywwbU7hTnrcVeZZ0qZ5DtJplDQAuHlFlLQQxk9jxtI16Ss40rKQloyXL1+O1hlHi9L5h8PhzCUtX2e+PW1KWghXP1U56cMR8yhp+b5ouy1KGgDcns58mS0AwCJR0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBpi5pp6enIiIiIguVRWQkDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShpLbzAYiIjcWeC6BgMljSXn+AamNRgMwps3b2aOvz/MQklj6Tm+gWkpaZRASWPpOb6BaSlplEBJY+lVHd+np6dyQ/nmm2+mDpRGSaMEShpLT0lT0mBaSholUNJCCMfHx6Hf71/J8fHx6L6Dg4M72aa43vPz87C5uXmr21Dl/Pw89Pv9sLa2Vnlfuo2Ttjl9jLPs50nrUdKUNJjWTZW0N2/ehA8++KDyPSfmgw8+CG/evLmjR05JlLTwtiwMh8O73pRa/X6/iJI2HA7HSmwq38ZptnmWkjZpPW1K2v379yv/WN6/fz8cHh6Gfr8fvv3229pi8u2334Z+vx8ODw9bl5k4z12XKiUNrrqpkvbBBx+Ew8PDxnUfHh6GDz744CYfHgtCSQvNJa1qtGd7e3v0Jl41T7w/WltbGys18f7z8/Mro3jn5+dX1hvnT0ew6uaLI12bm5tj99VNH0IIBwcHV0YQ62xubo6Wvb29feUxxm3M/121Xd99912rfZsXuHT/Ve2b3DQjabGQTVO2lDQljeVzUyUtfW+Y9ja6R0kL05e0OGoTC0culp7j4+NROUmXH0tMvC/enpa7vJik622aL11f1Gb6eF/dY0qnPTg4CNvb21dKUdNIWtV2Ne3bOGJXdco5LWlV683NWtKqRtLSUltV0j788MNw//79yunjNFWjdQ8ePBjd/vDhw8ptyv8dp43zPXjwYGzEMy5n2mnrtjs+1g8//LCyZOYF7G9/+1t49epV+Oabb8Lp6Wn429/+pqRRvLqS9v3331eOuj99+lRJY+6UtFB9TVo+YpUWiaqyk0qLTzpKtbm5ObaM+OZYNXrWVNKa5ktHrKI2008qOvly0iIatSlp6f1Njzfdh6WVtPv374fhcBhOT0/Dw4cPw4MHD8ZK2oMHD8KDBw9G89+/f39UfuI+zEfS0pKWT9empMX54jKrljPttJO2O+6DSSXtj3/8YwghjMqYkTQWQdNI2uPHj8feLx4/fmwkjRuhpIXpR9LykpaeOozW1tbC5ubmaJr4JpeOEKUjGGmqiklVSauaL5ab9FRk0/Tp45hU1uIIYJSvp01JS6dvU9K2t7eLKmlVpygPDw/HCk9a0KqmjyWvqqRVFbE2JS0f5Yv/vu60bba77tRuVQk7PT0d7XcljUUw6XRnLGpNBa2ppFX9TY5Jp6PblLRwMyUtLUbpCFpadPIRrrr1htA8kpZqKmlV01fNm6636r6qPyj5Nub/blvS4r4tdSSt7jqytKSl98fb8zx8+HAhSlrTdk9T0tLRNCWNRdDmmrQffvjBNWncKCUt3ExJS0+hpkUrLSp5can6QEHTNWlV81WVoTbriY+p6jRmCOPXiNXdNo+SlhfY9Lq+OG/8sECJJe3w8HB0CjTenl6bVjVPqSVt0nZPU9L+93//dxQljUXggwOUQEkL9d+Tlp+Gm6akhfC2lMX740X5adHJ1x3vqxs9ii/cuvmqylDT9CFc/XRnVVmNxahqmXn5i9Ol/25b0uo+OZvenu/3fL25eV+Tlv73w4cPw/37968Ul3Sa9Bq2OF1e+NoUsfQ6uJsuaW22u21JOzw8HH1Y4B//+Ef44x//qKRRPCWNEihpLL15l7T475iq0aWqC/bT8pnfPqmk5Z/AvI2SVrfd05a0f/zjH+Hw8DB888034dWrVz7dyULwPWmUQElj6fnFgduN70ljGfjFAUqgpLH0lDQlDabltzspgZK2RNp+AOImpNeFHR8fh7W1tbFrze6SkqakwbSUNEqgpC2Ru/wN0vi9cCVyfAPTUtIogZK2RNKvscg/Idn2k5RVn3Sd9F1l6friSFrdtCFc/Q659L5Jv2Vatc3x06l1o4SOb2BaSholUNKWSNNvi17nN0jT0jXNF8o2TZuP9qVlrM1vmVZtc5uSJiJyV4HrGgyUtKXR9Nui0/4GaRztit9rNq+Slv/6QdN91/ndVABYFkraEmn6st1pvpQ3/QmoqsJUNc88S1rT6da2XyQMAItOSVsi8ypp6Y/C58ueV0mLv3jQVODaPjYAWEZK2hKZR0lLL9xPTfP7mU3Ttrkmrc1vjKb3TbomDQAWkZK2ROZR0qpOOcby1fT7mel0k6ZN15FfWzbpt0yVNAC6QknjVuVla3NzM6ytrd3xVgFAeZQ0bl38+ox8tAwAeEtJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQksbSGwwGIpIFKN9goKSx5BzfLIvBYBDevHkzc7wmYDEoaSw9xzfLQkmDblHSWHqOb5aFkgbdoqSx9KqO79PT04UP3aOkQbcoaSw9JY1loaRBtyhphPPz89Dv98Pa2tqdbsfx8XHo9/vh4OBgrstV0lgWShp0i5JGGA6Hod/vh36/H46Pj+9sO+66pPX7/fDgwYOx27799tvQ7/fvrIgdHh6Gfr8fvv32WyUNJQ06RkkjbG5uhs3NzdDv98P29vbo9rw0bW9vh36/H87Pz0MIIRwcHIzKXV7w0uIXlx3nS+/r9/thOByOrS+uJ70vvT8m3466cjdNScsLkZJGSZQ06BYlrePiqc6Dg4Owvb09dsqzqaTF+WKJikUsnS/el5aqOF8sWHGZ6Xybm5shhLdl7vj4+Mr60vnmWdIePHgQ7t+/31jS0qIYy1Oc7sMPPxxN3+/3w8OHD0fTPnjwYKygPnz4cLTMvLjGET0ljVRdSfv+++/Hjp+Yp0+fKmmwwJS0jovl4Pz8fFR24ohYm5KWlqqqZebzRfko3Pn5+ZX1pcUsX+Y0p0anKWnffvtt+PDDD0cFKi9p9+/fH90Xt+nw8HA03XA4rDx9Gu+P/47z5uvOl6ukkWoaSXv8+PHYa+rx48dG0mDBKWkdt7a2NjZ6lp7ynHS6Mz0tWTUCVlXS0lOWdfflJW17e/vKSFPV6dA605a0WIzS8pWOah0eHo6VtuFwOJouvS8vV+m/02Wl81Tdp6QRTTrdGYtaU0FT0mBxKGkdlo6G5QlhckmrWs7BwcHYacp8vjYFLhavppG0aUxb0k5PT8PDhw/Dhx9+OFbSqk59xlG3WUpaXF/+HChp5Npck/bDDz+4Jg2WhJLWYXmZym9LR7JC+GnUra5QpadKm65Ji8uPxa/qdGcc2WvalrTczfOatLQM3b9/Pzx48ODGR9LyeY2kUccHB6BblLQOi6UrlX7CMoTxU5qTPt2ZnnpMT0+mF/mn642nSPNy1/bTnbFc3lRJi+VpmmvSZilp6eickkYVJQ26RUlj7vKRtM3NzTv9otzrlrTT09OxkbQ2n+687unOWMzifosjdEoaKSUNukVJ40bEEbJ81Osu+MUBloWSBt2ipLH0lDSWhZIG3aKksfSUNJaFkgbdoqSx9BzfLAslDbpFSWPpOb5ZFkoadIuSxtIbDAYikgUo32CgpAEAFEdJAwAokJIGAFAgJQ0AoEBKGgBAgZQ0AIACKWkAAAVS0gAACqSkAQAUSEkDACiQkgYAUCAlDQCgQEoaAECBlDQAgAIpaQAABVLSAAAKpKQBABRISQMAKJCSBgBQICUNAKBAShoAQIGUNACAAilpAAAFUtIAAAqkpAEAFEhJAwAo0KikiYgsQ/b29u58G0RE5pXeYDAIFxcXIiIiIlJIlDQRERGRAqOkiYiIiBQYJU1ERESkwChpIiIiIgVGSRMREREpMEqaiIiISIFR0kREREQKjJImIiIiUmCUNJEO5a6/OVtmz10fQyJye1HSRDoUr/XFjudPpFtR0kQ6FK/1xY7nT6RbUdJEOhSv9cWO50+kW1HSRDoUr/XFjudPpFtR0kQ6FK/1xY7nT6RbUdJEOhSv9cWO50+kW1HSRDqU67zWX716Ffb398OrV6/ufPu7Hn+rRboVJU2kQ5nmtf7dd9+Fd999N/R6vVF+8YtfhN3d3Vvf7r29vdDr9cK9e/fufB8uyvMnIosfJU2kQ2n7Wv/uu+/Cz372s9Dr9cIvf/nL8O6774Zf/vKXo7L2+9//fuIytra2xgper9cL6+vr19rumy5pcfvuehnzev5EZDmipIl0KG1f67/4xS9Cr9cL//Zv/zZ2+/7+/qi8NZ3+jAVtdXV1LtutpE33/InIckRJE+lQ2rzWd3d3Q6/XC//0T/9Uef/Gxkbo9XphY2Ojdhnr6+u1I2d5gVtdXQ29Xi9sbW2N3R+zsrIyKmkrKytjt8dlxvtj6srcvXv3rozs5betrKyEo6Oj2lHAeF+6XVXLaNquSY9nludPRJYnSppIh9LmtR5LWN0pzf39/dDr9cK7775bu4ymU51NJa1qxOzevXtjpSbe1uv1wt7e3ui+uPz83zFNxXHSKFhc39HRUWWBq1pG03Y1PZ5Znz8RWZ4oaSIdyjQlLT/VGdOmpF1cXFSWmdXV1caSlo+qxeTlLZ0ulq88+WhaPl1a1qpKWlxHmr29vbGRtHT6fBlN29X0eGZ9/kRkeaKkiXQobV7r3333XWMJ+5d/+ZfGEleVdORo3iUt/nebDyXUnX6sK1hxG9ORrrYlrWm7lDQRaRMlTaRDaftaj1+98d5774U3b96Mbo+jbL1eb+z2SUmLWV5QYgFqc7qzqtTkpw7bJF9efExHR0dXlp9uY5uSFpfRtF1Kmoi0iZIm0qG0fa2/evVq9AnPXq839vUbMe+9917t/FWnCtNPeqYX2seL59t8cKCu1OQjZPn6Li6unn5My1N6X7y96lRlU0mrWkbddilpItImSppIhzLNa/3NmzdhY2NjVNZ+9rOfhffeey/s7u6OvoajqajJ3T5/IrL4UdJEOpR5vdbTL7ud5to0KeP5E5HFiJIm0qHM87UefzbqLn4mqqvxt1qkW1HSRDoUr/XFjudPpFtR0kQ6FK/1xY7nT6RbUdJEOpTBYCALnrs+hkTk9qKkiYiIiBQYJU1ERESkwChpIiIiIgVGSRMREREpMIPBIPQ+/fTTO98QEREREXmbTz/9NPSGw2H461//eucbIyIiIiIX4ezsLDx69OinkbRHjx7d+QaJiIiIyEXY3d0Nn332WehtbGyER48ehcePH4cff/zxzjdMREREpIv58ccfw1dffRX+8z//M2xsbPxU0jY2NsKXX34Zvvrqqzv/skYRERGRLubrr78OX375ZYjd7P8DtUnAuhgtCwEAAAAASUVORK5CYII=)
Titel: Re: SQL-Fehler in Log bei Ticketsuche
Beitrag von: Tino Voigt am 07.02.2022 10:10:10
Hallo iis-mma,

ich konnte das Verhalten auf einem lokalen Testsystem mit der Framworkversion 17.14 nicht nachstellen.
Ihre Suche wird von dieser Meldung nicht beeinflusst werden, da sich die Meldungen auf die Config_Items bezieht.

Haben Sie in Ihrem KIX Erweiterungen installiert?

Viele Grüße, Tino
Titel: Re: SQL-Fehler in Log bei Ticketsuche
Beitrag von: floek am 10.02.2022 14:31:25
Hallo,


ich habe den gleichen Fehler. Wir sind auf KIX Pro 17.17.0-0. Außer KIX Pro haben wir nur KIXConnect installiert.
Woher kommt das?


Grüße
Florian
Titel: Re: SQL-Fehler in Log bei Ticketsuche
Beitrag von: iis-mma am 10.02.2022 14:37:58
Hallo,
wir haben folgende Debian-Pakete installiert:
# dpkg --list | grep kix
ii  kix                                 17.17.0-0                           all          KIX is the new standard for servicedesks. The software browser-usable, open source and based on the own development path of OTRS 5. KIX supports following areas: ITIL-based IT service, technical service, maintenance and repair, customer service.
ii  kix-pg                              17.17.0-0                           all          basic DBMS specific package for KIX
ii  kixpro                              17.17.0-0                           all          KIX Pro extends KIX for professional IT- and technical service.
ii  kixpro-connect                      17.17.0-0                           all          Connect extension for KIX Pro

Titel: Re: SQL-Fehler in Log bei Ticketsuche
Beitrag von: Tino Voigt am 08.03.2022 13:36:32
Hallo,

ist eventuell im SysConfig Schlüssel:
Ein dynamisches Feld mit einer Objekt-Referenz eingetragen? Wenn dem so ist, wird bei einer Volltextsuche, auch dieses mit durchsucht.
Ist dieses Feld eine Objekt-Referenz auf ein Config Item, wird eine solche Meldung geworfen.

Viele Grüße Tino Voigt
Titel: Re: SQL-Fehler in Log bei Ticketsuche
Beitrag von: floek am 09.03.2022 08:44:12
Ja, das scheint die Ursache zu sein. Besten Dank! Ich vermute mal das Logverhalten an dieser Stelle wird sich mit kix17 nicht mehr ändern, oder?